Spreadsheet: 753654d1635610294-sumif-s-top-3-value-and-conditional-formatting-example-5-cf-and-sumifsaggregate
Sheet: projections

Name | Team | fantasy poitns | conditional formatting cell for each individual team in cell d
[NAME] | DAL | 47.00655778772667
Nikola Jokic | DEN | 59.11265565814716
[NAME] | BKN | 55.10645875794733
[NAME] | LAC | 51.26916077399545
[NAME] | LAL | 44.32790848639115
[NAME] | LAL | 45.02456272118677
[NAME] | BKN | 42.6749653365632
[NAME] | LAL | 48.13251262884593
Domantas Sabonis | IND | 39.88337130602362
[NAME] | CHA | 47.49776973142691
[NAME] | CHA | 42.53272347562958
[NAME] | CHA | 30.81498734232305
[NAME] | DAL | 25.13509216041316
[NAME] | CLE | 35.47703606415782
[NAME] | CLE | 29.50006195683193
[NAME] | DEN | 23.60691626117013
[NAME] | CLE | 27.68712918729594
Mason Plumlee | CHA | 29.54734300779907
[NAME] | CLE | 35.02207157955475
[NAME] | LAC | 29.57011024396029
[NAME] | DEN | 32.77613152940859
[NAME] | CHA | 22.74906937090153
PJ Washington | CHA | 0.02597239067413954
[NAME] | LAC | 29.75077684028016
[NAME] | CLE | 35.44863115671158
TJ McConnell | IND | 24.01832598915303
[NAME] | IND | 28.22372965436838
[NAME] | IND | 20.61121513713913
[NAME] | CLE | 26.63036479332272
[NAME] | CLE | 22.58695568382653
[NAME] | DEN | 24.30429421215787
[NAME] | DAL | 25.83865798198115
[NAME] | LAC | 26.08845997569023
[NAME] | IND | 12.47493222453344
[NAME] | DAL | 32.05367559595879
[NAME] | LAL | 21.10977596947359
Blake Griffin | BKN | 13.44327394871445
[NAME] | LAC | 25.89658473448579
[NAME] | BKN | 19.49262606920115
[NAME] | BKN | 24.46401715762585
Justin Holiday | IND | 16.59103755790364
[NAME] | DEN | 18.27392505971609
[NAME] | LAL | 13.11958789214259
LaMarcus Aldridge | BKN | 20.04864753167351
[NAME] | LAL | 18.94454674380231
[NAME] | LAC | 22.68705381664034
[NAME] | DAL | 27.94863607403546
[NAME] | LAC | 20.02439677527168
[NAME] | BKN | 22.6663007065061
[NAME] | CHA | 21.52482400898922
[NAME] | IND | 12.89189216323716
[NAME] | DAL | 17.3425886496103
[NAME] | CHA | 25.6949356694316
Brad Wanamaker | IND | 14.46727627949966
[NAME] | DAL | 11.2043146356927
[NAME] | LAL | 18.61615829265768
[NAME] | CLE | 14.39934201658925
[NAME] | CHA | 18.0573262945124
[NAME] | DEN | 14.89824012188509
Moses [NAME] | DAL | 6.806374147327269
[NAME] | BKN | 2.600793444199829
Maxi Kleber | DAL | 23.24529155968042
PJ Dozier | DEN | 9.664981394459069
[NAME] | LAL | 12.84300923459292
[NAME] | CLE | 15.99967245985835
[NAME] | BKN | 5.684339683200997
[NAME] | IND | 17.52927264580001
[NAME] | DEN | 10.71843641856229
[NAME] | LAL | 16.81805025336458
[NAME] | LAC | 17.97292212329203
[NAME] | BKN | 11.53498263367817
[NAME] | IND | 5.743473215863105
JaMychal Green | DEN | 9.524004207665648
[NAME] | LAC | 15.53550586162341
[NAME] | BKN | 4.779367109830682
[NAME] | DEN | 2.602753107870839
[NAME] | DEN | 3.428439446912756
[NAME] | DEN | 14.27972239476043
Bol Bol | DEN | 3.183550914990416
[NAME] | DEN | 1.469331191534038
[NAME] | DAL | 4.895736434904235
[NAME] | DAL | 2.340441034108305
[NAME] | DAL | 0.8553735479915389
[NAME] | DAL | 7.981399809526864
Avery Bradley | LAL | 5.122493935198215
[NAME] | LAL | 9.61716340427944
Denzel Valentine | CLE | 0.4322149820318706
[NAME] | CLE | 2.072328573723342
[NAME] | CHA | 0.3982313805100276
[NAME] | LAC | 7.591843455516712
[NAME] | LAC | 4.12359342859771