A B C D E
1 Acc Code Acc Name Div Dept $
2 60001 Com - Tel Rm 350
3 60002 Com - HP Rm 450
4 60003 Com - Fax Rm 650
5 60001 Com - Tel FB 750
6 60002 Com - HP FB 850

Report of Rm Div/Dept To show
Com Cost 1450

Report of FB Div/Dept To show
Com Cost 1600

Com Cost is made up of acc code from 60001 to 60003

ie I would like to set a formula to search for 60001 to 60003 in column A,
Rm in column B and Rm in column C and then return the sum

Please help and thank you in advance