Countif not working.....

  • Thread starter Thread starter sh0t2bts
  • Start date Start date
S

sh0t2bts

Hi Guys,



I need to count how many people are in my list, my list starts at row 2 and
ends at row 19 the cells are populated by other formulas:-

=IF('Thu 01st'!A3=0,"",('Thu 01st'!A3))

So if there is no value to be picked up the cell displays "" or nothing., I
now use this countif "=COUNTIF(A3:A19,"<>""")" to see how many people are
listed but it always comes back with 17



What am I doing wrong ???



Cheers



Mark
 
Not as elegant as Aladin's, but a way of doing it with COUNTIF:-

=COUNTA(Rng)-COUNTIF(Rng,"")

Any blank cells will kill it though, but you said they all had formulas.
 
Aladin,

I think that that is very good lateral thinking but doesn't it work just as
well as simply:

=SUMPRODUCT(1-(A3:A19=""))

Regards

Sandy
 
Back
Top