=SUMPRODUCT Col E = B, Col F = blank

  • Thread starter Thread starter 77Debbie77
  • Start date Start date
7

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!!
 
77Debbie77 said:
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!!
Click to expand...

Replace NULL with "".
 
#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
 
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)
 
I tried it and I still get #NAME? error

Bob Phillips said:
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)
Click to expand...
 
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.
 
You can stop wasting your time Dave, she multiposted and got her answer

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#NAME? 5
Lookup Formula 4
Scrabble Value calculation for Welsh words 0
Multi-Worksheet Sumproduct & Listing 3
Is there a more efficient way to write this SUMPRODUCT 4
conditional formatting using a formula 4
Trying to match 1 value to multiple columns 10
if function (if more that 7 nesting) 2

Back
Top