Summary Sheet Formula - Basic

Jacks

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])

Partcheasy

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])

Jacks

Thank you. I knew it was something real simple I was missing, but I was just too tired to figure it out last Thursday.