Sum by Month

3wing ✭✭✭
edited 01/06/23 in Formulas and Functions

We have a sheet that has a delivery fee, same day booking fee and pickup fee. I want to total those amounts per month based on the rental start date at the bottom of the sheet. We also have a tip column that would also need to be totaled separately per month. I'm new to smartsheet - so any help would be appreciated.

Best Answer

  • 3wing
    3wing ✭✭✭
    Answer ✓

    @Mike Wilday I got it figured out. I totaled the columns first - then added the totals together using this formula: =SUMIFS(TOTAL:TOTAL, [Rental Start Date]:[Rental Start Date], AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2022)) Thanks again for your help. I'm all set!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!