S
starguy
I want to count nonblank cells in A5:A50 if corresponding cells in
B5:B50 are blank.
B5:B50 are blank.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvi Laanemets
Hi
SUMPRODUCT(--($A$5:$A$50<>""),($B$5:$B$50=""))
SUMPRODUCT(--($A$5:$A$50<>""),($B$5:$B$50=""))
S
starguy
what is the role of -- in this formula and others.
B
Bob Phillips
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
explanation.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
A
Arvi Laanemets
And I forget to preceede the second comparision with -- . So the correct
formula must be
=SUMPRODUCT(--($A$5:$A$50<>""),--($B$5:$B$50=""))
formula must be
=SUMPRODUCT(--($A$5:$A$50<>""),--($B$5:$B$50=""))