have a calendar that displays every profit and loss, but I want to figure out the fee, so how do I sum with the requirement that it be in January?

`=SUMIF(MONTH(K2:K512),1,N2:N513)`

I tried to use this formula did not work error

Feb 26, 2023 in Others 206 views

## 1 answer to this question.

Your error is because your formula is invalid due to the fact that the first argument must be a range. In your example, that first argument is an array.

• 38,010 points

## How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

## How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

## How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

I created a key pair pem file ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE