I want to select cells that are separated from each other (not in a range) and find the average of the ones that have a number in them. AVERAGEIFS does not seem to work because it only lets me average numbers in a range. What I want to do is AVERAGE(A1,C1,E1) and only include a cell if it is filled in.

Additionally, I want to average duration of minutes:seconds (18:42) in the same way but this is already hard enough and Google Sheets duration formats are disastrous.

How can I average numbers that are not right next to each other only if they are not blank, and how can I average duration in mm:ss at all?

1 Answers

player0 On

use AVERAGE instead of AVERAGEIF