=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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks