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
$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