Forum Discussion
CLexcel1960
Jan 22, 2021Copper Contributor
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.
1 Reply
- SergeiBaklanDiamond Contributor