Forum Discussion

CLexcel1960's avatar
CLexcel1960
Copper Contributor
Jan 22, 2021

Formula to average except when there are blanks or divide by zero errors

Hi.  I want to write a formula that only executes when the cells being averaged are not blank and when they will not result in divide by zero errors.

This is one of the options I've tried but all result in an error in the formula.

=round(AVERAGEifs(L4:N4,>0,L4:n4<0,L4:N4),0)

I appreciate any help.

Resources