| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
=SUMPRODUCT(--(TEXT(A1:A25,"mmm")=B1))
Neater ! ... but think the range A1:A25 needs to be fixed: $A$1:$A$25 before copying down from C1 <g -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells based on date range in another column | New Users to Excel | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
| Formula that will count between dates ranges | Excel Worksheet Functions | |||
| Formula that will count between dates ranges | Excel Worksheet Functions | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
Threaded Mode
