Hi,
I need some help on adding ;
I have data for 52 weeks which looks like this:
wk1 wk2 w3...........
Act Pl Pl
50 45 45
10 25 10
If the week is Act ( actuals) I need it to look up the val 50. and if the week in Pl ( planned) in need it to look up 25 and 10.
so in the end I need the total in my total cell to be 50+25+10=75.
Any ideas?
Thanks
I need some help on adding ;
I have data for 52 weeks which looks like this:
wk1 wk2 w3...........
Act Pl Pl
50 45 45
10 25 10
If the week is Act ( actuals) I need it to look up the val 50. and if the week in Pl ( planned) in need it to look up 25 and 10.
so in the end I need the total in my total cell to be 50+25+10=75.
Any ideas?
Thanks