I want to show the average of a range if any cell is populated. However, my formula shows the average only if the first cell is populated.
I'm using the below formula:
If A2 is populated, the formula's output is not blank, which is expected.
And if A2:C2 is all blank, the formula's output is blank as expected.
However, if A2 is blank while B2 and C2 are populated, the formula's output is blank, which is not what I want:
How do I get the output of the formula to be blank only if the entire range is blank?