Thread: how to sum highest ranking values meeting criteria within a limit?
View Single Post
  #5   Report Post  
 
Posts: n/a
Default
Instead of deploying Sum(Rank(1:32)) ...... ,

you may wish to experiment with :
SUM(LARGE(TargetRange,ROW(INDIRECT(ROW()&":"&ROW() +31)))).

The reference TargetRange is self-evident.

Regards.

Reply With QuoteReply With Quote