Using the same formula, I want to be able to sum 3 different sets of data
independently based on a pointer in a cell. For example:
A B C D E F G H
I
1
2 10 20 30
3 5 10 15
4 First 2 4 6
5

Using a formula in cell A5, based on the information in cell A4, sum the
appropriate row. In cell A4, First = row 2, Second = row 3, Third = row 4.
The above answer in cell A5 would be 10+20+30=60. If I changed A4 to
"Second", then the answer in cell A5 is 30.

Can this be done?