Excel - sum a column of sales monthly and quarterly?
I have a number of columns: date, sale, tax, etc.
I want to separately sum the sales and tax by month, quarter,and year. Thanks in advance, |
Use a pivot table. You can group by those increments. See
Intro to Pivot Tables http://peltiertech.com/Excel/Pivots/pivotstart.htm Grouping: http://www.contextures.com/xlPivot07.html In article , "HarryMangurian" wrote: I have a number of columns: date, sale, tax, etc. I want to separately sum the sales and tax by month, quarter,and year. Thanks in advance, |
All times are GMT +1. The time now is 10:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com