When you say "the user selects row 5 with a $50 value", how does he
select it? By landing the cell cursor on row 5? Typing "5" into an
input box, or into a cell? Your solution depends on how you're
collecting data. The ultimate answer will likely include a SUM and
OFFSET formula, but determining the arguments and where they come from
is the question mark for me right now.