This is likely something you guys could create while sleeping :)
I'm trying to create a sumproduct formula that accounts for 3 row conditions and 1 column.. Please see the attached as it explains the request in more detail
I tried an Index/match formula but I have too many nested match conditions
Thank You
Sum Product Multiple Criteria
-
- 5StarLounger
- Posts: 1180
- Joined: 22 Jul 2013, 18:29
Sum Product Multiple Criteria
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Sum Product Multiple Criteria
With the aid of a helper row (the yellow row), you can lookup the value based on the four conditions specified.
I'm not sure what you want in the table in I17?
Updated attachment... for second calc (but not sure what you need??)
I'm not sure what you want in the table in I17?
Updated attachment... for second calc (but not sure what you need??)
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 1180
- Joined: 22 Jul 2013, 18:29
Re: Sum Product Multiple Criteria
so simple.. I forgot to remove the data in I17.. Thank You Rudi