Home |
Search |
Today's Posts |
#1
|
|||
|
|||
complex fomula: counting cells that are blank
I have a range of cells that I need to count and they must meet certain
criteria. I have found that if the cell is blank, it will count it instead of eliminating it from the criteria. Here is the sumproduct formula I have been using: =SUMPRODUCT(--('Wpg #s data'!C2:C642="Incident"),--('Wpg #s data'!G2:G642<D2)) I need to eliminate a count for cells that are blank in the G column. Column G contains the date and time of the record. So, it should ask, is it an incident, and is the date greater than a specific date, and eliminate it in the count if it is null. Possible? |
#2
|
|||
|
|||
Your formula is "asking" if it is LESS than a specific date (in D2), try
flipping the sign around to a "". "shmurphing" wrote in message ... I have a range of cells that I need to count and they must meet certain criteria. I have found that if the cell is blank, it will count it instead of eliminating it from the criteria. Here is the sumproduct formula I have been using: =SUMPRODUCT(--('Wpg #s data'!C2:C642="Incident"),--('Wpg #s data'!G2:G642<D2)) I need to eliminate a count for cells that are blank in the G column. Column G contains the date and time of the record. So, it should ask, is it an incident, and is the date greater than a specific date, and eliminate it in the count if it is null. Possible? |
#3
|
|||
|
|||
=SUMPRODUCT(--('Wpg #s data'!C2:C642="Incident"),--('Wpg #s
data'!G2:G642<D2),--ISNUMBER('Wpg #s data'!G2:G642)) shmurphing wrote: I have a range of cells that I need to count and they must meet certain criteria. I have found that if the cell is blank, it will count it instead of eliminating it from the criteria. Here is the sumproduct formula I have been using: =SUMPRODUCT(--('Wpg #s data'!C2:C642="Incident"),--('Wpg #s data'!G2:G642<D2)) I need to eliminate a count for cells that are blank in the G column. Column G contains the date and time of the record. So, it should ask, is it an incident, and is the date greater than a specific date, and eliminate it in the count if it is null. Possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
how to skip the blank cells | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |