| 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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add totals from a range of dates depending on the month?
Hi!
Try this: =SUMPRODUCT(--(MONTH(A1:A12)=8),B1:B12) Just change the month number (=8) as needed. Biff "Confused" wrote in message ... 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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add totals from a range of dates depending on the mon
Thanks Biff ... u da best!!! :o)
"Biff" wrote: Hi! Try this: =SUMPRODUCT(--(MONTH(A1:A12)=8),B1:B12) Just change the month number (=8) as needed. Biff "Confused" wrote in message ... 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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add totals from a range of dates depending on the mon
You're welcome!
Biff "Confused" wrote in message ... Thanks Biff ... u da best!!! :o) "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(MONTH(A1:A12)=8),B1:B12) Just change the month number (=8) as needed. Biff "Confused" wrote in message ... 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) |
| Reply |
| 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 | |||
Linear Mode
