M
Michael DD
Hi.
I have a row of four values i need to find the average.
If all 4 rows have a value no problem i know what to do,
but, If only 3 rows have a value i need a function that
will add the three and divide by 3 not four.
What I am looking for is a formula that will ignore the
zero value and add the remaing values and divide the sum
by the number of values?
Michael D
I have a row of four values i need to find the average.
If all 4 rows have a value no problem i know what to do,
but, If only 3 rows have a value i need a function that
will add the three and divide by 3 not four.
What I am looking for is a formula that will ignore the
zero value and add the remaing values and divide the sum
by the number of values?
Michael D
