LinkBack URL
About LinkBacksI am using this formula to average the values in cells F49:J49 if the value
is greater than zero.
=SUMIF(F49:J49,">0")/COUNTIF(F49:J49,">0")
When all values are 0, I'm getting the division by zero error.
Just a little help please...
I am using this formula to average the values in cells F49:J49 if the value
is greater than zero.
=SUMIF(F49:J49,">0")/COUNTIF(F49:J49,">0")
When all values are 0, I'm getting the division by zero error.
Just a little help please...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks