If Statement?

Vanessa

New Member
Joined
Mar 26, 2006
Messages
23
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,227
Office Version
  1. 365
Platform
  1. Windows
.. so in the end I need the total in my total cell to be 50+25+10=75.
I assume that you mean 85?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,963
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top