SUMIF Issues with Zero, Negative, and Positive values

[vzc6rp]

Using Excel 2007 on Windows XP


From the chart data below I am trying to use the SUMIF function to sum the values where the value is not equal to Zero but is either a negative or positive value.

I can get it to sum using the following value. The value in Cell E9 is =SUMIF(B50:C9,">0") and it matches the value from Cell D9, great.

However, it will not work for Cells E4 or E13.

In Cell D4 I have entered =SUM(B2:C4) and it gives me the corrent count. However in Cell E43 when I enter =SUMIF($B2:$C4,">0") the value does not match what I expected from D4.

The same for Cell D13 and Cell E13.

How can I write this to give me the values Column E I see in Column D?

CHART DATA:

A B C D E
1 "Date" "Growth" "Previous" "Weekly" "Test Column"
2 1/06/2010 282 -20,049
3 1/07/2010 276 165
4 1/08/2010 301 183 -18842 1207
5 1/11/2010 315 206
6 1/12/2010 258 193
7 1/13/2010 297 211
8 1/14/2010 288 178
9 1/15/2010 212 150 2308 2308
10 1/19/2010 265 193
11 1/20/2010 115 143
12 1/21/2010 0 -449,123
13 1/22/2010 0 0 -448407 716

 

[VoG]

Possibly

=SUMIF(B50:C9,"<>0")

 

[vzc6rp]

Wow, that worked, so simple. I guess I was over thinking this issue.

I appreciate your help.

 

[barry houdini]

I'm not sure I understand, if you sum without zero that's no different from summing with zero, so why not just use SUM?