software

I want to count nonblank cells in A5:A50 if corresponding cells in
B5:B50 are blank.--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=535422Hi

SUMPRODUCT(--($A$5:$A$50lt;gt;quot;quot;),($B$5:$B$50=quot;quot;))--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;starguyquot; gt; wrote in
message ...
gt;
gt; I want to count nonblank cells in A5:A50 if corresponding cells in
gt; B5:B50 are blank.
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=535422
gt;

what is the role of -- in this formula and others.--
starguy
------------------------------------------------------------------------
starguy's Profile: www.excelforum.com/member.php...oamp;userid=32434
View this thread: www.excelforum.com/showthread...hreadid=535422See www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;starguyquot; gt; wrote in
message ...
gt;
gt; what is the role of -- in this formula and others.
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=535422
gt;
And I forget to preceede the second comparision with -- . So the correct
formula must be
=SUMPRODUCT(--($A$5:$A$50lt;gt;quot;quot;),--($B$5:$B$50=quot;quot;))--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;starguyquot; gt; wrote in
message ...
gt;
gt; what is the role of -- in this formula and others.
gt;
gt;
gt; --
gt; starguy
gt; ------------------------------------------------------------------------
gt; starguy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32434
gt; View this thread: www.excelforum.com/showthread...hreadid=535422
gt;