I'm trying to write a formula that will take the average of a range in the sheet named "Adjusted 3 Month Avg" the range of the cells I need an average of start on '!T50:V50. However, if one of the cells is blank, I need to get the average of the two remaining cells. For Example, if cell U50 is blank, I need the Average of T50 and V50. If T50 is blank, I need to get the average of U50 and T50 and so on and so forth.
Solved by K. E. in 29 mins