View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Edwards[_2_] Richard Edwards[_2_] is offline
external usenet poster
 
Posts: 24
Default 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