Countif

[sferreira81]

I am having a problem with a countif formula. I'm trying to count all cells not equal to <10/<10. I was trying to use =COUNTIF(RANGE,"<><10/<10"), but it didn't work, so the computer tech at my company told me to try =COUNTIF(RANGE,"*/10")+COUNTIF(RANGE,"10/*"), but I'm having problems with it. I have three cells not equal to <10/<10, but it is only counting one. This is driving me nuts! It seems to be something so simple and I can't figure it out. I also need to minus any blanks and zeros in the formula.


Thanks,


Shelley Ferreira

 

[Debraj]

Hi Shelley..


Welcome to the forum..


Can you please try the below for me..

=COUNTIF(RANGE,"<>"&"<10/<10")


in addition.. you can use.. below also..


=SUMPRODUCT((Range<>"<10/<10")*(Range<>"")*(Range<>0))

for additional query..


try COUNTIFS also.. if 2007+ edition you have..


Regards,

Deb

 

[sferreira81]

The first formula counted every cell with a number in it (includes zeros) and the second one worked!!! Now I don't have to rip out my hair! Lol! Thank you very much!!

 

[Debraj]

Hi Shelley!


Thanks for feedback..


1st formula is actually for your computer tech.. and

2nd one is specially for you!!..


Regards,

Deb