Hi everyone! Hope you’re all having a nice life!
I have this sheet with a formula/function to calculate the average
=IFERROR(AVERAGE(D5:I5);" ") and it works, to some extent, since some or even all cells may or may not have any value, they might be blank, which generates a problem; the average shown in J5 won’t be as exact. For example, let’s say that in that range of cells D5:I5 only D5 contains a value, unless I’m wrong, I think the result shown in J5 should be the one obtained from the division of that value by the number of cells, in this case 6, however, if the value of D5 is 12 in J5 is shown 12 and not 2, as it should be, then my question is, what formula/function should/can I use to make that happen? I tried
=AVERAGEIF but it didn’t work, I probably did it wrong. Thanks in advance for your answers.