Posted to microsoft.public.excel.programming
|
|
Checking for empty cells in a range
=sumproduct(--(isblank(b7:b30))+--(isblank(c7:c30))
--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38047
|