multiple sumif or sumproduct

[Richard Edwards]

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

 

[Jarek Kujawa]

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

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

adjust yr ranges

HIH

 

[Richard Edwards]

went for #1 - perfect - apart from the ; which i replaced with ,

thx

 

[Jarek Kujawa]

oops, missed that, am using a Polish version
sorry
;-(