Forum Discussion
Taking values from certain rows based on data input
So I'm trying to get a value into the column "Cat A Tied" (C column). This value depends on the number in the "# People Tied With" column (D Column). In this case, cell D2 has the number 3 in it. I w...
The only change needed is to divide that SUM value by the value in cell D2. But thank you so much for your help!
=IF(D2="","",SUM(OFFSET($B$1,ROW(D2)-1,,D2)))/D2
