# 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

• 12.7 KB Views: 11

#### bosco_yip

##### Excel Ninja
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

#### ardrianz

##### New Member
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
Thank you so much @bosco_yip many thanks

#### John Jairo V

##### Well-Known Member
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!