| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Counting with Date Range as Criteria
You could use this:
=SUMPRODUCT((TEXT(Master!A2:A10,"mmmyy")="Oct09")* (TRIM(Master!B2:B10)<"")) The TRIM is an added precaution to avert spurious results due to presence of any pure white spaces within col B -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Julie" wrote: Thanks for the help everyone. Can we take it one step further? What if I want to count any record that has something entered into column B, no matter what it is, for the October date range? In other words, all the NonBlanks in column B for a given date range? I very much appreciate it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
| counting a number of cells with 2 range criteria | Excel Discussion (Misc queries) | |||
| Conditional Formula, counting one criteria in a range based on ano | Excel Worksheet Functions | |||
| Counting cells in a range per multiple criteria . . . | Excel Worksheet Functions | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
