If Statement?

[Vanessa]

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

 

[Krishnakumar]

Hi,

=SUMIF(A2:C2,"act",A3:C3)+SUMIF(A2:C2,"pl",A4:C4)

HTH

 

[Peter_SSs]

.. so in the end I need the total in my total cell to be 50+25+10=75.

I assume that you mean 85?