not equal to zero

<>0 is the way to write not equal to zero,are you summing or counting??
--
paul
remove nospam for email addy!



"ellebelle" wrote:

> =SUMIF(BX11:BX51,0,AJ11:AJ51)
>
> this function almost does what i want except i want to count values that do
> NOT equal zero - this counts values that do eaual zero.
>
> If I put the sign < infront of the 0 then it errors - what do I write?
>
>

=SUMIF(BX11:BX51,0,AJ11:AJ51)

this function almost does what i want except i want to count values that do
NOT equal zero - this counts values that do eaual zero.

If I put the sign < infront of the 0 then it errors - what do I write?

<>0 is the way to write not equal to zero,are you summing or counting??
--
paul
remove nospam for email addy!



"ellebelle" wrote:

> =SUMIF(BX11:BX51,0,AJ11:AJ51)
>
> this function almost does what i want except i want to count values that do
> NOT equal zero - this counts values that do eaual zero.
>
> If I put the sign < infront of the 0 then it errors - what do I write?
>
>