=SUMPRODUCT Col E = B, Col F = blank

[77Debbie77]

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

 

[Glenn]

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

Replace NULL with "".

 

[Pete_UK]

#NAME? means that Excel doesn't recognise something as the name of a
function (or named range), and NULL does not exist - use "" to
indicate blank (no space between the two quotes). There is also an
ISBLANK() function that you could use.

Hope this helps.

Pete

 

[Bob Phillips]

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]

I tried it and I still get #NAME? error

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)

 

[Dave Peterson]

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.

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Dave Peterson]

I saw that new thread after I posted.

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

--

Regards,

Peo Sjoblom