| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count the number of cells containing a date within a range
=COUNTIF(A1:A100,"="&B1)-COUNTIF(A1:A100,""&C1) if your limits (inclusive)
are in B1 and C1. -- David Biddulph "Scoffers" wrote in message ... Investigated using COUNTIF but from what I can see you need to set specific criteria i.e. an exact date rather than just a cell with any date in it. I know I could count the blank cells and take them from the total number of cells using COUNT but this is long winded. Any help welcome. -- Scoffers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells in column that contain number in a range | Excel Worksheet Functions | |||
| How do I count the number of records within a date range | New Users to Excel | |||
| How do I count the number of records within a date range? New issu | Excel Worksheet Functions | |||
| count number occurring within specific date range | Excel Worksheet Functions | |||
| count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
