| 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!! |
| 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) | |||
Threaded Mode
