| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore Blanks in Countifs statement
I have a single countifs statement that has 3 lists referenced to it.
=COUNTIFS(Data!F$2:Data!F$199,2,Data!E$2:Data!E$19 9,E1,Data!g$2:Data!g$199,F1,Data!h$2:Data!h$199,G1 ) I am trying to have this act as a query system. If one of these list boxes(Cells E1,F1,G1) is left blank I would like it to be ignored. Therefore I can have all 3 or a mix of the 3 boxes chosen to see what the difference is in the data it pulls. Can someone assist me with this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median - Ignore blanks | Excel Discussion (Misc queries) | |||
| Ignore blanks in multiplication formula | Excel Worksheet Functions | |||
| DATA Validation (Ignore Blanks) | Excel Discussion (Misc queries) | |||
| Data Validation - ignore blanks | Excel Discussion (Misc queries) | |||
| USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
Threaded Mode
