not equal to zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Zeros in a row until encounter first non-zero value 9
COUNT IF NOT EQUAL TO ZERO 12
Countif a corresponding value is not equal to zero or blank 1
Sumif problem with zero value and blank cells 6
NumberFormat for small non-zero numbers? 2
Counting 2
formula result is zero but zero is not populating in cell 3
Displaying zeros in cells 2

Back
Top