Ok here's the situation:
I am averaging 4 cells out of a possible 6. 2 cells are constant. The other 2 cells are chosen from a possible 4 cells depending on a search function in my formula.
Still, all in all, 4 cells are being averaged. Yet, when one of these 4 cells is blank, I get a value error. There is an error formula in this blank cell that returns blank based on the formula.
I want the formula to average depending on the number of values are present. So if there are 3 values present, then it divides by 3, two values present, divides by two, and so on...
=AVERAGE(O11,IF(ISERROR(SEARCH("throws R",T11)),BC11*4.2,BO11*4.2),IF(ISERROR(SEARCH("at",T11)),CM11*4.2,CA11*4.2),(AF11*4.2))
Bookmarks