1.
=SUMPRODUCT((A1:A100="Bob")*(B1:B100="Cat")*
(C1:C100="House");D1:D100*E1:E100*F1:F100/G1:G100))

2. =SUM(IF((A1:A100="Bob")*(B1:B100="Cat")*
(C1:C100="House");D1:D100*E1:E100*F1:F100/G1:G100)))
(array-enter this formula i.e. CTRL+SHIFT+ENTER)

adjust yr ranges

HIH



On 3 Lis, 10:31, "Richard Edwards" wrote:
Morning all,

Column A = Bob
Column B = Cat
Column C = House
Column D = 10
Column E = 5
Column F = 1.6
Column G = 100

I am trying to write a formula that will do: (((d*e)*f)/g) based on whether
the data in A,B and C all confirm to certain criteria...a couple of hours,
multiple coffees and a cake and i cannot put it together...

can some clear headed individual help out?

thx vm

richard