CODEWITHSUNDEEP
excelexcel-formula
man nameless
man nameless

Reputation: 1

Getting 0 using AVERAGEIF function in Excel

I have a column of 1011 rows of values (E1 is header) and some of them are blank, I want to fill those blank cells by the mean of all other non-empty cells in that column.(filled cells and blank cells are in the same column, no 0 in the column).So I tried this function in one of the blank cells:

=AVERAGEIF(E$2:E$1012,"<>")

I got 0 using this function.Can I only calculate the value on other cells and put it back to the blank cells?

I have searched for a while how people use AVERAGEIF function and I think my problem is because the range includes the cell with the formula itself, causing infinite self referencing loop.As i can see people are all using this funtion in other row than the range.

Upvotes: 0

Views: 126

Answers (1)

Dominique
Dominique

Reputation: 17493

If you want to skip blank cells, you can simply use the AverageA() function, no need to write an AverageIf() for this.

Upvotes: 0

Related Questions