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.

The neatest way for your data is with a pivot table

See here
http://www.datapigtechnologies.com/f...es/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

--
Allllen


"Erinayn" wrote:

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.

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.

"Allllen" wrote:

The neatest way for your data is with a pivot table

See here
http://www.datapigtechnologies.com/f...es/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

--
Allllen


"Erinayn" wrote:

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.