| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Non-Blank Cells in Column If a Reference Criteria Met.
Hi.
Cells A4:A1000 contain Dates (1/1/08, 2/1/08, 3/1/09...) Cells D4:D1000 contain Data (22, 143, 46,...) Cell A1 Will contain my search criteria (2009...) In Cell D1 I need to have a count of Non-Blank Cells D4:D1000 that are in the year of Cell A1 A B C D 1 2009 1 2 3 4 1/1/08 22 5 2/1/08 143 6 3/1/09 46 Thank you for any help. M. E. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference last non-blank cell value from a column cells? | Excel Worksheet Functions | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| count non blank cells with criteria | Excel Discussion (Misc queries) | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
Threaded Mode
