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,