I am trying to create a formula that does not recognize a missing value. The formula is as follows:
=(C15+D15+E15+F15+G15)/5*B15
The question I have is how do I change the “5” in the formula so that if I am missing a data point in any of the cells listed it does not use 5 but uses only the cells with data in them? Really what I am looking for is a formula that only uses cells that have data so the answer is not being reduced more than it should be since it only uses cells with data…
HELP…