Or just:
=SUMPRODUCT(--(ISBLANK(B7:C30)))
But I would think that the OP wanted a programming solution--since Chris posted
in .programming.
anilsolipuram wrote:
=sumproduct(--(isblank(b7:b30))+--(isblank(c7:c30)))
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=380477
--
Dave Peterson