You wouldn't even need OFFSET, I think. Something like:
=SUMPRODUCT((ISNUMBER(MATCH(A1:A10,LARGE(A1:A10,{1,2,3}),0)))*B1:B10)
Regards
You wouldn't even need OFFSET, I think. Something like:
=SUMPRODUCT((ISNUMBER(MATCH(A1:A10,LARGE(A1:A10,{1,2,3}),0)))*B1:B10)
Regards
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks