Formula Help please

[Guest]

I just need a formula that I'm sure you can all help with. I have a data set
that is as follows:

Invoice #, Code, Description, Amt, Date Paid (Q1, Q2, etc.)

I need to update our schedule with the sum per code per quarter e.g.:

Code Date Sum
A.1 Q1 $43
A.1 Q2 $35
A.1 Q3 $38
A.1 Q4 $38
T.3 Q1 $12
T.3 Q2 $57 and so on.

Thanks in advance.

 

[Guest]

The neatest way for your data is with a pivot table

See here
http://www.datapigtechnologies.com/flashfiles/pivot1.html
http://www.datapigtechnologies.com/ExcelMain.htm

and here
http://peltiertech.com/Excel/Pivots/pivottables.htm


you just need to
1) clcik in the middle of your data somewhere
2) click on data > pivot table
3) let excel select you data and do finish
4) drag code into the rows and quarter into the columns

 

[Guest]

Can't believe I didn't think of a pivot table. Just didn't even occur to me.
Thanks I got exactly what I needed - just needed a reminder I guess.