multiple sumif or sumproduct

  • Thread starter Richard Edwards
  • Start date
R

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
 
J

Jarek Kujawa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with lots of formulas 3
Formula for looking up and copying from another worksheet? 1
Find text in N columns and one Row 1
Counting cells with SUMPRODUCT and conditionals...? 1
Formula than understands midnight? 26
Is there a way to use a multiple column array in SUMPRODUCT? 2
Combine text under different condition 3
Vlookup? 1

Top