Using Excel 2000, I developed a grid incorporating +, -, words and values.
The abbreviated grid looks like this:
       B         C
3  Average   1
4      +         2
5      +         3
6      -          4
7      +         5
8      +         6
9      +         7
10 Average   8
11    -          9
12    -          10
13    -          11
14    +         12
15    -          13
16    -          14
17 Average  15

In cell B19, I set up the following formula: =SUMIF(B3:B17,"+",C3:C17).
Instead of returning the expected result of 35, the value was 12 (value in
B14). I even tried replacing all of the +'s and -'s (using letters) but the
formual result was 0 instead of 35. What went wrong? Thanks for any help!