• 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.

Highest values from a set of values

ardrianz

New Member
Hi
I have a monthly set of values from which I am getting the sum of the best 12. Now I have a corresponding set of values for the same months, for which I need to count the number of occurrences for those months only which were considered as the best 12 months. The attached excel file has the details.

Requesting help in solving this.
 

Attachments

  • Marks and Project.xlsx
    12.7 KB · Views: 11
Try,

1] "Best 12 of 13 marks" in P3, formula copied down :

=SUMPRODUCT(LARGE(C3:O3,{1,2,3,4,5,6,7,8,9,10,11,12}))

2] "No of Project" in AD3, formula copied down :

=COUNTIF(Q3:AC3,"Y")-(COUNTIFS(Q3:AC3,"N",C3:O3,MIN(C3:O3))=0)

Regards
 
Hi, to both!

Another one's:
1. =SUM(C3:O3)-MIN(C3:O3)
2. =COUNTIF(Q3:AC3,"Y")-(COUNTIFS(Q3:AC3,"Y",C3:O3,MIN(C3:O3))>0)

Blessings!
 
Back
Top