When all numbers in C20:I20 are less than equal to 0 or C20:I20 empty/blank or the range contains at least a #DIV/0! error or all numbers are text numbers, a #DIV/0! result would follow...I am using this formula =SUM(C20:I20)/COUNTIF(C20:I20,">0"). If there is a 0 in any cell that this formula is dividing by the result is a Div/0! error. Does anybody know why I am getting this error?
Thanks.