# Automating Summing Daily Data to Generate Monthly Total

edited 06/20/22

Hello,

I have a spreadsheet with data different days of each month. I need to sum the number of data so that it provides a total for each month. For example, for the month of June, I will need to sum all incoming 30 data for each day to generate a monthly total. How can I do this so that the result is generated automatically on a monthly basis?

Grateful for any help.

• ✭✭✭✭✭
edited 06/20/22

Ahoy Vinton,

Definitely leverage the Sheet Summary formula option for this! I'm doing the same thing for a few projects, and this is what my formula looks like:

=SUMIFS(OrderTotalCost:OrderTotalCost, OrderEntryDate:OrderEntryDate, AND(MONTH(@cell) = 1, YEAR(@cell) = YEAR(TODAY())))

in the AND(MONTH(@cell) = 1 that "1" means January

If you wanted it to be for June, it would be:

=SUMIFS(OrderTotalCost:OrderTotalCost, OrderEntryDate:OrderEntryDate, AND(MONTH(@cell) = 6, YEAR(@cell) = YEAR(TODAY())))

In YEAR(@cell) = YEAR(TODAY() keeps it working in the year that it is now. If you wanted it to be for last year it would be: YEAR(@cell) = YEAR(TODAY(-364)))

Good luck!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!