Does anyone know what formula is needed to get excel to calculate all A rates seperate from B rates and C rates example 10 A rates @ 50.00 9 B rates @ 40.00 and 6 C rates @ 30.00 so although the rates could be mixed up (not following in any particular order the result which I would like to appear on a separate spreadsheet would be A = 500.00 B = 405.00 C = 180.00 then to get them to total up = £1085.00

Hope this makes sense.

A 50.00

B 40.00 then separate sheet with answer a 100.00 b 40.00 c 60.00

A 50.00

C 30.00

C 30.00