| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count non blank cells with a condition?
Hi Jason,
Am Wed, 15 Aug 2012 12:36:45 +0000 schrieb Jay07: _______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. try: =SUMPRODUCT(--(LEN(B1:B100)0),--(A1:A100=DATE(2008,4,1)),--(A1:A100<=DATE(2010,3,31))) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| 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
