| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to ignore blank date cells in sumproduct | Excel Discussion (Misc queries) | |||
| SUMPRODUCT - Ignore blank rows | Excel Worksheet Functions | |||
| Simple Sumproduct of 2 Columns, with some blank cells in range | Excel Discussion (Misc queries) | |||
| sumproduct with 0/blank cells | Excel Worksheet Functions | |||
| sumproduct--counting--zero--blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
