Excel - sum a column of sales monthly and quarterly?

[Guest]

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]

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