Formula to sum by month, quarter, year

Iron Contributor

Hi All,

 

I have a spreadsheet which contains multiple tabs and is uploaded into another system. The contains information which shows for each month, quarter and year. Currently the sum for each quarter and year is manually calculated. Given the large data set, and number of sheets which get uploaded i am wondering if i can use a formula to automatically calculate this for  me. I have a sample attached of monthly data, with the formula's and how i sum currently. 

 

If there are any suggestions to improve this process to make it more efficient and easier to use going forward, please let me know. Appreciate any insight/ideas.

 

Kind regards,

1 Reply

@calof1 

maybe with filter...

How To Filter Data By Quarter In Excel?

standard disclaimer: none Microsoft site

 

or determine quarter with formula

=ROUNDUP(MONTH(A1)/3,0)

A1= is Date format

 

Simple suggestions that might help you.

 

NikolinoDE

I know I don't know anything (Socrates)