Summary Sheet Formula  Basic
In a financial sheet we have monthly totals. I would like to create a summary for each quarter. I am able to only include 2 months at a time. How can I include the total for Mar 2xxx?
=SUM(([Jan 2xxx]:[Feb 2xxx]))
I found this formula which gave me an Invalid Operation error
=sum([Jan 2023]:[Jan 2023]) + ([Feb 2023]:[Feb 2023]) +([Mar 2023]:[Mar 2023])
Answers

Hi Jacks  if I'm reading your formula right, you just forgot to add "sum" to the other two months, I would think it would work if you added them in as here:
=sum([Jan 2023]:[Jan 2023]) + sum([Feb 2023]:[Feb 2023]) + sum([Mar 2023]:[Mar 2023])

Thank you. I knew it was something real simple I was missing, but I was just too tired to figure it out last Thursday.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!