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
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