I'm having the same problem. I tried Domenic's suggestion but didn't work -
any others?

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<X",B1:B100)

Hope this helps!

In article ,
CCrew2000 wrote:

I'm trying to sum a column of data "B", but only if column "A" does not equal
X.