Need SumIF help

[smashclash]

Below is a preview of my worksheet. What I'm trying to get excel to do is sum column I in row 47 if the number in Column F does NOT equal 0. For some reason excel will not recognize the "<>0" to not include the 0 accounts. However, if take the same formula and replace teh<> with =, it only adds the 0's? I could probably just use multiple if statements to include everything except the 0, but there has to be a way to simply exclude anything that is a 0. Any ideas???
(one other thing, not sure if it matters, but the columns D-H are text). Thanks in advance.

 

[Cbrine]

Not sure what the issue is, but I tested your formula on a blank sheet, and the "<>0" does work as the criteria for the Sumif(). Could it be the formats of your values? Are they text values?

 

[Brian from Maui]

Try,

=SUMIF(F35:F39,"<>0",J35:J39)

=SUMIF(F35:F39,">0",J35:J39)

 

[plettieri]

Hi:

Your formula seems to work for me....possible text items for your criteria...

plettieri

 

[smashclash]

Try,

=SUMIF(F35:F39,"<>0",J35:J39)

=SUMIF(F35:F39,">0",J35:J39)

Hmmm, that is returning 0 for my sum. That makes no sense. What is wrong with my excel?

 

[smashclash]

OK, well I deleted everything that was in column F and retyped what used to be in there. Also changed the format of the column to "Number." Seems to work now. I guess it's one of those excel "resets?"

 

[Aladin Akyurek]

Since the F-range houses text values, not numbers, the parser runs wild with respect to SumIf...

Try instead:

=SUMPRODUCT(--(F35:F46<>0&""),I35:I46)