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...
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.
Subodh_Tiwari_sktneerYes that's brilliant! Thanks so much!
Would you mind explaining how it works please, as I like to learn these things for future use?