S starguy Apr 24, 2006 #1 I want to count nonblank cells in A5:A50 if corresponding cells in B5:B50 are blank.
B Bob Phillips Apr 24, 2006 #4 See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation. -- HTH Bob Phillips (remove nothere from email address if mailing direct)
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed explanation. -- HTH Bob Phillips (remove nothere from email address if mailing direct)
A Arvi Laanemets Apr 24, 2006 #5 And I forget to preceede the second comparision with -- . So the correct formula must be =SUMPRODUCT(--($A$5:$A$50<>""),--($B$5:$B$50=""))
And I forget to preceede the second comparision with -- . So the correct formula must be =SUMPRODUCT(--($A$5:$A$50<>""),--($B$5:$B$50=""))