Calculate a total based on Month

Hello,
I have had a request to calculate totals by month and by current month for some dashboarding. I am struggling to work with dates and how to separate by month. I don't have a current test formula, but any general notes on how to work with dates easily in formulas would be a great place to start.
Thanks!
Best Answer
-
Small update - I believe I answered this.
=SUMIF({Compost Tracker Range 3}, =MONTH(TODAY()), {Compost Tracker Waste})
The first cross-reference is a column that is pulling the month from a date column using - =MONTH(Date@column)
Answers
-
Small update - I believe I answered this.
=SUMIF({Compost Tracker Range 3}, =MONTH(TODAY()), {Compost Tracker Waste})
The first cross-reference is a column that is pulling the month from a date column using - =MONTH(Date@column)
-
Awesome!
I'm glad you got it figured out, also thank you for posting your solution.
Need more information? ๐ | Help and Learning Center
ใใใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao! ๐ | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!