SUMIF Formula not working

RIP2632

New Member
Joined
Oct 15, 2005
Messages
11
I have a SUMIF formula that is not bringing back the correct data. Here is one of the formulas, =SUMIF($C$2:$T$43,"704",N$2:N$43). The range is the same for all of the formulas but the criteria changes as well as the sum range. There are 4 columns (sum ranges) that I am trying to sum. The first one worked correctly and the last one worked correctly, but the two in the middle do not bring back the correct data.

Any help would be appreciated.

Cameron
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
With SUMIF the sum range must be the same size as the criteria range. If you don't specify it that way then Excel forces it anyway. Your formula is the same as

=SUMIF($C$2:$T$43,"704",N$2:AE$43)

i.e. if only T43 in your criteria range is equal to "704" then it'll return the value from AE43.
 
Upvote 0
I would like the formula to retrun the sum of all cells in column "N" that have "704" in the same cell in column "C". I have double checked the calculation and it grabbing extra data as it is not the correct figure.
 
Upvote 0
=SUMIF($C$2:$C$43,"704",N$2:N$43)

If you have numbers, not text, in column C then you shouldn't use the quotes
 
Upvote 0
Have you tried without the quotes?

=SUMIF($C$2:$C$43,704,N$2:N$43)

What result do you get, zero, incorrect sum or an error?
 
Upvote 0
Hi:

You might try verifying that the items in column N are numbers and not text.

plettieri
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,986
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top