I have a Google Sheet with a variable number of data rows. I would like to sum the three highest values from a certain column, but they won't necessarily be in the top three cells. An empty cell should be treated as zero, if there are only one or two rows with data so far.
How can I achieve this? The closest thing I can think to do is
MAX(A1:A2000) but that only gets the one very highest value, without accounting for the second- and third-highest.