Mar 30 2022 08:30 PM
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,
Mar 31 2022 12:14 AM
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.
I know I don't know anything (Socrates)