LookUp

[Joe]

What formula should I use to add all the sums posted to a
particular Code. Each code has its own description saying
what works that code covers. I need to collect all the
amounts for each code to a summary sheet.
I may need to find out more regards laying the data out,
so any help to find a web site for this would be
appreciated.
Regards
Joe

 

[Frank Kabel]

Hi Joue
you may have a look at pivot tables for this:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html