• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumproduct? Sumif? Offset? What do I do?

fred

Member
Here is a question:

$AMT PAYEE1 PAYEE2 PAYEE3 PAYEE4
438 A B
409 C A B D
171 B A D
248 C
117 B A C D
122 B
217 C A

Answers: A = 1352, B = 1257, C = 991, D = 697

I can use a long sumif formula to get the result of sales reps A, B, C and D. Or a long sumproduct formula (see attached). But how do I incorporate it with offset/match? My ultimate goal is to make it shorter and cleaner.

Thanks.
Frederick
 

Attachments

  • sumproduct sumif offset question.xlsx
    9 KB · Views: 11
Back
Top