Total the Value of Orders in a given month

  • Thread starter Thread starter Wolverine
  • Start date Start date
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..
 
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!
 
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.
 
Sounds like a job for Data > Subtotals........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing total sales formula 1
Calculating total amount in a Pivot Table 1
Summarizing monthly worksheet totals 1
Date Format and Sumproduct 9
Difference function and argument for two simple amounts 8
sum the number of rows in a spreadsheet given 2 criteria??? 3
Count the number of orders in a given month 3
Group by month in a Pivot table 2

Back
Top