Well, the problem with this approach is that if you look at J4 and review the row of responses we had, 100% and 98%, I would need the formula to recognize that there are only 2 values and thus would need to update weighting to 80% for Column G (G1) and 20% for Column I (I1). Same would happen for other rows, which is the hard part about all of this. But I think you were on the right track and thanks for the quick response!

I may have stated that slightly wrong. So let me try again:

Cell G1 = 0.20 or 20%

Cell I1 = .10 or 10%

After it is determined those are the only 2 columns with data for a given month, then the weighting I think should be manipulated in the formula to reflect:

Cell G1 would actually be 0.667 or 66.7%

Cell I1 would actually be 0.333 or 33.3%

Maybe my math is not working tonight, but I basically need the weighted %'s to move depending on what items we have or do not have within the formula for each month, while leaving Row 1's Weighted percentages as displayed.