Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Almas Akhtar   on Nov 07 In MS Office Category.

  
Question Answered By: Sairish Kauser   on Nov 07

Not sure if this simplified view makes sense:
=SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array5)
)
/
SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array4)
)

Looks like your Arrays 1,2 & 3 have the common 'selection' logic across the two
functions. The difference applies to (Array5)/(Array4).

Which translates to:
=SUMPRODUCT(
(Array1=Condition1)
*(Array3=Condition3)
*(Array2=Condition2)
*(Array5)/(Array4)
)

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Please Help me in this Formula Or get search suggestion and latest updates.


Tagged: