Total the Value of Orders in a given month

W

Wolverine

Hi,

Thanks in advance for any help you can give... I am running Exce
2002....

I need to calculate the total sales for a given month from a sheet
Each order is inputed on a separate row. Column E is the date of eac
order... Column L is the $ amount... The sheet spans about 3 years...

I need to return the sum of sales for each month to a cell..
 
D

Domenic

Hi,

If we use June, 2004, as an example of the month whose total sales we
want, try:

=SUMPRODUCT((MONTH(E2:E1000)=6)*(YEAR(E2:E1000)=2004)*(L2:L1000))

Adjust the ranges accordingly.

Hope this helps!
 
A

Aladin Akyurek

Pivot tables would be one option.

Another is...

=SUMPRODUCT(--(YEAR($E$2:$E$100)=YEAR(A2)),--(MONTH(($E$2:$E$100)=MONTH(A2))
,$L$2:$L$100)

where A2 houses a date in the form of 6/1/04 (1-Jun-04) to indicate the
month/year of interest.
 
Top