Sumif(s) top 3 value and conditional formatting

Hey,

How can you sumifs the top 3 value for each teams and conditional formatting for each individual team?

Thanks.

Originally Posted by Metoo7

formula for B2 in your top 3 sheet:

=SUM(LARGE(IF(projections!$B$2:$B$92=$A2,projections!$C$2:$C$92),{1,2,3}))

It is an array formula, fill this formula to the range [B2:B9].


For your second question of 'formatting for each individual team', please provide details with a clear example.

Thanks

In the projections sheet, I want to do conditional formatting for example: BKN (MIN-Max), then CHA (MIN-MAX), etc..

B2=IF('top 3'!$A2<>"",SUMIFS(projections!$C$2:$C$1000,projections!$B$2:$B$1000,'top 3'!$A2,projections!$C$2:$C$1000,">="&AGGREGATE(14,6,projections!$C$2:$C$100/(projections!$B$2:$B$1000='top 3'!$A2),3)),"")

Copy down

Thanks CARACALLA and Metoo7.

You are welcome

worksheet name : top 3

Cell B2 formula , Drag down

Formula:

=SUMPRODUCT(SUMIFS(projections!$C:$C,projections!$B:$B,$A2,projections!$C:$C,">="&LARGE((projections!$B$2:$B$92=$A2)*(projections!$C$2:$C$92),3)))