Average if - to be correct if one of the cells is blank
I am trying to average, correctly, 3 separate cells across a row. If one or more of the cells is blank, it is not averaging correctly.
I know I need to somehow include if it's greater than 0, but can't seem to work it out.
Always tweaking things at the beginning of the year :) Thanks!!
Help Article Resources
Check out the Formula Handbook template!