| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to count non blank cells with a condition?
Hi all,
I need to count non blank cells in a column where the date for that row (but different column) falls between two dates For Example... _______A_________B 1__05/04/2008___TEXT 2__16/10/2011___ 3__29/03/2010___ 4__09/12/2011___TEXT 5__01/01/2010___TEXT I need to count all of the non blank cells in column B where the date in Column A is between or equal to 01/04/2008 & 31/03/2010. In the example there is only B3 that matches this criteria so the formula should return 1. Anyone know how to do that? Many thanks Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting non blank cells according to a condition | Excel Discussion (Misc queries) | |||
| count cf cells displaying condition 3 | Excel Discussion (Misc queries) | |||
| Count cells with condition | Excel Worksheet Functions | |||
| Count filtered cells meeting a condition | Excel Discussion (Misc queries) | |||
| how do I count pairs of cells when each matches a condition? | Excel Discussion (Misc queries) | |||
Threaded Mode
