SUMIF Formula not working

[RIP2632]

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

 

[RIP2632]

This formula brings back the correct sum, =SUMIF($C$2:$T$43,"704",J$2:J$43)

This formula does not bring back the correct sum, =SUMIF($C$2:$T$43,704,N$2:N$43)

This formula does not bring back the correct sum,=SUMIF($C$2:$T$43,"704",O$2:O$43)

This formula brings back the correct sum, =SUMIF($C$2:$T$43,"704",P$2:P$43)

I am not sure why one works and not another. Please help.

 

[plettieri]

Hi:

Can you confirm the items of interest in columns J, N, O, and P are in fact numbers (and not text).


Try copying the items in Colum J to Column O....results?



plettieri

 

[barry houdini]

I don't understand why you are using the range $C$2:$T$43

As I explained in an earlier post, this means that your sum range won't be limited to column N. If you only want to sum column N when column C is "704" use

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

 

[RIP2632]

Posted: Mon Sep 25, 2006 8:12 pm Post subject:

--------------------------------------------------------------------------------

I don't understand why you are using the range $C$2:$T$43

As I explained in an earlier post, this means that your sum range won't be limited to column N. If you only want to sum column N when column C is "704" use

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

...and barry is the winner. It was a formatting error. I see the logic behind it now. Thanks all for your help.