Counting Blanks
 

I need a formula which counts blanks within the range b1:b200

Ive tried countif(b1:b200,0) or countif(b1:b200,"0")

neither work, any help is much appreciated


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=398138

T De Villiers Wrote:
I need a formula which counts blanks within the range b1:b200

Ive tried countif(b1:b200,0) or countif(b1:b200,"0")

neither work, any help is much appreciated

Try this ...

=COUNTIF(B1:B200,\"=\"&\"\")

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=398138

This works too...

*=countif(B1:B200,"")*


--
Leebo
------------------------------------------------------------------------
Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=398138