Hello all, I'm using Excel 2003 and need help as to whether I need to use either of the subject formulas.
I have a number of sheets titled the Vehicle Registration Number, eg ABC-123, DEF-456, GHI-789 ETC. These have various columns where Colmumn A has a title of "Category" and the following are listed therefunder: Fuel, Repais, Hire, etc. Another Column has the "Total Costs" associated with these.
I need a Summary Sheet that lists the Vehicles (ABC-123 etc) across the columns in Row 1 and then in Rows 2, 3, 4 etc tally the costs of those in Column A, Fuel, Repairs etc.

Hope I have explained it well enough, cheers, thank you
Pete