All Questions
Tagged with error-correction average
1
question
1
vote
1
answer
4k
views
How can I stop AVERAGEIF formula returning #DIV/0
I have the following formula returning #DIV/0! when all 5 cells are blank:
=AVERAGEIF(CV17:CV21,">0")
Spreadsheet image
This is being used to average call time over the period of a 5 day working ...