| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF headscratcher
Hello,
I have a column of dates like below in cells A1:A11. 10/04/2007 21/08/2006 10/04/2006 16/04/2007 28/02/2005 16/01/2006 20/05/2003 01/03/2005 28/02/2005 13/10/2003 26/06/2006 What I would like to do is put a formula in the cell below (say A12) to look at the whole range (A1:A11) and then count the cells that have a date between 01/04/2007 and 31/07/2007 (in the above example it would return 2). I'm not sure if I should be using SUMPRODUCT for this as I am not too au fait with that and it's getting late in the day!! Any help greatly appreciated. Cheers, Ant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =countif ??? | Excel Discussion (Misc queries) | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Threaded Mode
