How to total items if they fall between a date range  
Author Message
jspayneco





PostPosted: Tue May 17 13:30:51 CDT 2005 Top

Excel Misc >> How to total items if they fall between a date range

I have a range of items that fall under a date range.
I am trying to total the items that fall under a certian date range.

ie.
20-Apr-05 25-Apr-05 1-May-05 16-May-05
A $1.00 $0.00 $0.00 $0.00
B $19.00 $0.00 $10.00 $0.00
C $0.00 $5.00 $0.00 $0.00
D $0.00 $0.00 $0.00 $20.00
total $20.00 $5.00 $10.00 $20.00

If dates fall between 1-Apr-05 and 30-Apr-05, total totals = $25.00
If dates fall between 1-May-01 and 31-May-05, total totals = $30.00
If dates fall in the year 2005, total totals = $55.00

How do I do this?

Excel474  
 
 
Ron





PostPosted: Tue May 17 13:30:51 CDT 2005 Top

Excel Misc >> How to total items if they fall between a date range

>I have a range of items that fall under a date range.
>I am trying to total the items that fall under a certian date range.
>
>ie.
> 20-Apr-05 25-Apr-05 1-May-05 16-May-05
>A $1.00 $0.00 $0.00 $0.00
>B $19.00 $0.00 $10.00 $0.00
>C $0.00 $5.00 $0.00 $0.00
>D $0.00 $0.00 $0.00 $20.00
>total $20.00 $5.00 $10.00 $20.00
>
>If dates fall between 1-Apr-05 and 30-Apr-05, total totals = $25.00
>If dates fall between 1-May-01 and 31-May-05, total totals = $30.00
>If dates fall in the year 2005, total totals = $55.00
>
>How do I do this?

Assume your row of dates is NAME'd "Date" and your total row is NAME'd
"total".

The formula would be:

=SUMIF(Dates,">="&StartDate,total)-SUMIF(Dates,">"&EndDate,total)


--ron