multiple sumif or sumproduct
 

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

multiple sumif or sumproduct
 

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

multiple sumif or sumproduct
 

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

thx


"Jarek Kujawa" wrote in message
...
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

multiple sumif or sumproduct
 

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

On 3 Lis, 11:34, "Richard Edwards" wrote:
went for #1 - perfect - apart from the ; which i replaced with ,

thx

"Jarek Kujawa" wrote in message

...



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- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -