I'm struggling to figure out an if/then formula that will calculate the average of the previous cells and ignore any cells that have the value of "0." I only want an average of any cell that has a number <0. How do I put this into a formula?
I'm struggling to figure out an if/then formula that will calculate the average of the previous cells and ignore any cells that have the value of "0." I only want an average of any cell that has a number <0. How do I put this into a formula?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks