This is what I want to achieve:

If the value in A1:A10 = ABC and the value in B1:B10 = DEF, then add
the corresponding values in C1:C10 and multiply that by D1

I have tried:
=SUM(IF((A1:A10,"ABC")*(B1:B10,"DEF"),C1:C10,0))
but that doesn't work, and I haven't even got to multiplying the total
of the sum_range.

Ultimately I need to complete that argument three times, where the
values in the A, B and D columns would differ.

i.e.

(IF (A1:A10 = ABC and B1:B10 = DEF) ADD (C1:C10)*D1) PLUS
(IF (A1:A10 = GHI and B1:B10 = JKL) ADD (C1:C1)*D2) PLUS
(IF (A1:A10 = MNO and B1:B10 = PQR) ADD (C1:C1)*D3)

Can this be achieved in Excel? Is an IF statement the correct syntax?

Any help appreciated.


--
Captain Grey
------------------------------------------------------------------------
Captain Grey's Profile: http://www.excelforum.com/member.php...o&userid=33804
View this thread: http://www.excelforum.com/showthread...hreadid=535751