Hi,

Since Com accounts run from 60001 - 60003, this is duplicate information.
So you could create the following formula:

SUMPRODUCT(--(LEFT(B1:B5,3)="Com"),--(D1:D5="Rm"),E1:E5)

If this hleps, please click the Yes button

Cheers,
Shane Devenshire

"Cheryl" wrote:

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