Calculating monthly sales totals
Hey everyone,
I'm stuck with something on my Excel sheet and could really use some help. I've got this list of sales and their dates, and I'm trying to work out how to add up the sales for each month.
So, column C has all the sales dates, and column D has what each sale was worth. I need to find a way to total up the sales for just one month at a time, like march 2023, but I'm not sure where to start.
Here's an example:
03/01/2023 | 500
03/05/2023 | 700
04/12/2023 | 300
03/20/2023 | 450
05/15/2023 | 600
03/25/2023 | 800
04/09/2023 | 550
Thanks in advance for your help!
Hi,
I suggest you using Pivot Table function.
You can find this function in the "Insert" menu bar.
If you need more help, please add a file without any confidential data.
Sincerely
Thanks for the quick response!
Pivot tables are a bit tricky for me. I'm actually looknig for a simple formula.
Attached is a file with no sensitive data.
Any help with that formula would be great!
Cheers!
Arising from your csv file, the question is to know if data are presented as you wrote in your first post or as in your csv file
The file I attached has the same setup as in my first post. Dates are in column C and the amounts are in column D. Hope this makes things clearer!
Dates are in column C and the amounts are in column D.
Heu not really.... Herein a view of data in csv file
That's weird, when I double-click on the csv file, I get this:
Maybe we're not on the same version of Excel.
That's weird, when I double-click on the csv file, I get this:
I think it's due english version which use comma instead of --> ;
Find attached a file which shows you an exemple with SUMPRODUCT formula or Pivot table
Pivot table :
- Click in pivot table show you option in excel menu bar to adapt data range source via specific icon
- Right click in the pivot table and choose "Update" to actualise
Formulas :
- with SumProduct in the table or SumIFS
(I hope you understand my english explanations....
That's awesome, thanks a lot! I'm gonna take some time to dig into all of this!
Ok. You're welcome