I saw that new thread after I posted.

Peo Sjoblom wrote:

You can stop wasting your time Dave, she multiposted and got her answer

--

Regards,

Peo Sjoblom

"Dave Peterson" wrote in message
...
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

--

Dave Peterson