Racing points season, each driver can use best 75% (1/4 drop rate). when I do Sum(), SUMPRODUCT(), Large() I get errors because of the Null values
Sample:
Race#
DriverName 1 2 3 4 5 6 7 8 9 10 11
driver 1 49 49 48 49 48 48 50 50
driver 2 0 50 50 49 50 49 49
driver 3 45 46 46 47 48 48
driver 4 49 48 50 49 47 0
driver 5 48 48 47 47 47
driver 6 46 45 45
driver 7 50 50
driver 8 0 47
driver 9 44
only 8 races completed, 6 Largest of those count (3/4). I want the Current score of 6 best races.
correct result
Driver 1 = 295
Driver 2 = 297
Driver 9 = 44
My first post so sorry if I didn't do this right, I normally can just read the forum and find my answers.
Bookmarks