Hey Guys,
Can some one please help me with the following problem. suppose my execel looks like as below
Activity Day1 Day2 Day3
T1 10 10 10
T2 20 20 20
T3 30 30 30
T4 40 40 40
Now I need to do the following. In one of the cell below this if I type
T1 30
(basically if i type T1 then it find where T1 is and sum that row from col2 to end)
if I type
T2 60
If I type
T3 then it should show 90.
Hope some one will have idea on how to do this ?
Thanks
Raj.
Can some one please help me with the following problem. suppose my execel looks like as below
Activity Day1 Day2 Day3
T1 10 10 10
T2 20 20 20
T3 30 30 30
T4 40 40 40
Now I need to do the following. In one of the cell below this if I type
T1 30
(basically if i type T1 then it find where T1 is and sum that row from col2 to end)
if I type
T2 60
If I type
T3 then it should show 90.
Hope some one will have idea on how to do this ?
Thanks
Raj.