Skip to main content

All Questions

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 ...
Ben Nicholas's user avatar