|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 28th, 2008, 05:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUMPRODUCT Col E = B, Col F = blank
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!! 
|
|
#2
August 28th, 2008, 05:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
77Debbie77 wrote:
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 "".
|
|
#3
August 28th, 2008, 05:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
#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 On Aug 28, 5:11*pm, 77Debbie77 wrote: 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!!
|
|
#4
August 28th, 2008, 05:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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!!
|
|
#5
August 28th, 2008, 05:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
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!!
|
|
#6
August 28th, 2008, 06:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
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
|
|
#7
August 28th, 2008, 07:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
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
|
|
#8
August 28th, 2008, 09:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT Col E = B, Col F = blank
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
