Forum Discussion

Copper Contributor

Sep 17, 2019

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...

Columns

data

excel

Formulas and Functions

Rows

Tables

Subodh_Tiwari_sktneer

Silver Contributor

Sep 17, 2019

Drakerla

Please try this and let me know if this is what you are trying to achieve.

In C2

=IF(D2="","",SUM(OFFSET($B$1,ROW(D2)-1,,D2)))

and then copy it down.

Drakerla

Copper Contributor

Sep 17, 2019

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