| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add totals from a range of dates depending on the month?
I am trying to write a formula to add all totals for each month irrespective
of the year. So an August total and a September total in this case. Any ideas??? 30/08/2006 $70 30/08/2006 $45 30/08/2006 $21 01/09/2006 $35 01/09/2006 $100 01/09/2006 $50 30/08/2007 $70 30/08/2007 $45 30/08/2007 $21 01/09/2007 $35 01/09/2007 $100 01/09/2007 $50 Thanks :o) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM a range of sales based on month | Excel Worksheet Functions | |||
| Count dates for previous month | Excel Worksheet Functions | |||
| Lookup based on range of dates | Excel Worksheet Functions | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Threaded Mode
