Are you using an English version of excel?

Are you using R1C1 Reference style (do you see numbers or letters across the
top)?

Share what you tried.



77Debbie77 wrote:

I tried it and I still get #NAME? error

"Bob Phillips" wrote:

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!!




--

Dave Peterson