Hello all,
Thank you for looking at this post!
I'm attempting to make a formula that will negate the need for multiple sub calculation formulas. I'm trying to wrap up a couple of calculations in one formula, but running into issues when trying to calculate blank cells. The average function (just looking at cells) ignores blanks and just uses the average of actual numbers provided, but when I try to make all of these calculations in one cell, the average function doesn't recognize "" as a blank, or to ignore. Take a look at the example and let me know if you can think of any ways to help deal with these blanks.
Bookmarks