Forum Discussion
Formula to sum by month, quarter, year
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 qu...
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)