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.


--
rlchavdaPosted from http://www.pcreview.co.uk/ newsgroup access