Excel - sum a column of sales monthly and quarterly?

HarryMangurian · May 17, 2005

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,

JE McGimpsey · May 17, 2005

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