Hi EMoe,

=SUMPRODUCT(--(ISBLANK(A7:A30,C7:C30))) Doesn't work

One way:

=SUMPRODUCT(--(ISBLANK(A7:A30)--(ISBLANK(C7:C30))))

---
Regards,
Norman



"EMoe" wrote in message
...

Hello,

Both formulas posted work great. The COUNTBLANK one is the simpliest.
However, how do you add other ranges like C7:C30 to the formula with
getting the too many arguments message?

=SUMPRODUCT(--(ISBLANK(A7:A30,C7:C30))) Doesn't work

=COUNTBLANK(a7:A30,C7:C30) Doesn't Work

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=380477