| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Use
=SUMPRODUCT((MONTH(C5:C33)=1)*(M5:M33)) "RayG" wrote in message ... HI, I need to sum a colum of numbers in cells M5:M33 if it is between the dates 1/1/05 and 1/31/05 dates are in cells C5:C33. In other words in January. THANKS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
| Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| Filtering with dates | Excel Discussion (Misc queries) | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Threaded Mode
