Using Countif

[rskip]

I am using countif to count how many times a name appears in a list using the following formula
=COUNTIF ($B$1011:$B$1833,AZ32)
This works except the list contains zeros, and I dont want it to count zeros !
So if AZ32 is a zero, I want it to return a zero.
Help please !

 

[Joe4]

One way:

=IF(AZ32=0,0,COUNTIF($B$1011:$B$1833,AZ32))

 

[rskip]

Thank you, works as wanted , Cheers