=SUMPRODUCT Col E = B, Col F = blank
No it is "", no space
=SUMPRODUCT(--('Closed calls as of 70108'!$E$2:$E$65141="B"),
--('Closed calls as of
70108'!$F$2:$F$65141=""))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"77Debbie77" wrote in message
...
I am using the formula below to try and get the total count of Col F when
it
is blank (Col F is text data and some employees did not enter a comment)
when
Col E = B. But I am getting the #NAME? error.
Also, I'm not sure what the correct way is to write if blank, is it " " or
NULL or ""?
I am using Excel 2003
=SUMPRODUCT(--('Closed calls as of 70108'!$E$2:$E$65141="B"),--('Closed
calls as of 70108'!$F$2:$F$65141=NULL))
Looking for help. Thank you so much!!
|