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