Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

8 points

Having a problem with SUMIF

I'm new to numbers and I am having a problem with SUMIF. Here is my formula:

=SUMIF(MONTHNAME(MONTH(Checking::Transactions::$B3:$B24)),B1,Checking::Transacti ons::$F3:$F24)

The error says that SUMIF requires that all range arguement are the same size.

This basic, same formula is used on the same sheet and it works just fine ( =SUMIF(Actual Montly Expenses::$Month,B1,Actual Montly Expenses::$Amount) ).

There are 2 differences. My new formual uses data from another sheet for the columns. In the formula where it works, the 2 columns are next to each other, whereas in the formula that doesn't work, the columns are separated by 4 columns. Does this make a difference?

Expenditure	Month	Amount
Insurance	January	$2,000
Trash Collection	January	$406
Lighting	January	$197
Landscaping	January	$479
Legal/Audit/Taxes	January	$80
Snow Removal	January	$1,250
Trash Collection	February	$406
Snow Removal	February	$1,250
Lighting	February	$198

I tried using column header titles, but for some reason, the selected areas are different sizes.

Any suggestions?

User uploaded file

iMac, OS X Mavericks (10.9.1)

Posted on Feb 21, 2014 7:09 AM

16 replies

DaveH123 Author

Level 1

8 points

Feb 27, 2014 12:56 AM in response to DaveH123

Thanks to all for your help, but with the various suggestions, I came up with a solution.

It appears that using MONTHNAME(MONTH(B3)) broke the range, I created a hidden column next to the date column that used MONTHNAME(MONTH(A1)) to extract the Month name from the date entered. Then, my SUMIF function worked just fine.

Don't really understand where the unequal columns came from. When I selected the columns when building the original formula, I clicked on the column headings for each column and Numbers just decided to select those parts of the column.

Anyway, thanks again to all. Sorry I stirred up a small hornets nest with the question.

Having a problem with SUMIF