LinkBack URL
About LinkBacks
Hello RS, try this...
=SUMPRODUCT((A2:A10=1.75)*(ROW(A2:A10)>=LARGE((A2:A10=1.75)*ROW(A2:A10),3)),B2:B10)
Adjust the ranges.
If range doesn't have at least three 1.75 values in A2:A10, will give an error.
Hello RS, try this...
=SUMPRODUCT((A2:A10=1.75)*(ROW(A2:A10)>=LARGE((A2:A10=1.75)*ROW(A2:A10),3)),B2:B10)
Adjust the ranges.
If range doesn't have at least three 1.75 values in A2:A10, will give an error.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks