I need an updated excel formula to only average the values in a range that actual have data in them. I am currently using:
That formula is also factoring in blank cells, and I only need it to average cells that have values (Dates) in them, i.e., >0
See the attached example. I am starting with Column O Cell 1. I will need to update P1: P10 also, but I think I should be able to handle that based on someones solution for Column O.