Dear macasst, Good Evening.
I´m not sure if I understood correctly your desire.
Suppose you need the answer at column P
DO this:
P2 -- =IF('2011 Actual'!L2="McSpadden",'2011 Actual'!M2,0)
Now, select the P2
Copy
Select now the P3 to P65 cells
Paste
Tell me if it worked for you.
Mazzaropi
--------------------------------------------------------------------------
Quote:
Originally Posted by macasst
What is the correct formula to use in place of this very long formula? I can't figure out how to do a conditional formula over the range of cells from L2 through L65.
=IF('2011 Actual'!L2="McSpadden",'2011 Actual'!M2,0)+IF('2011 Actual'!L3="McSpadden",'2011 Actual'!M3,0)+IF('2011 Actual'!L4="McSpadden",'2011 Actual'!M4,0)+IF('2011 Actual'!L5="McSpadden",'2011 Actual'!M5,0)+IF('2011 Actual'!L6="McSpadden",'2011 Actual'!M6,0)+IF('2011 Actual'!L7="McSpadden",'2011 Actual'!M7,0)+IF('2011 Actual'!L8="McSpadden",'2011 Actual'!M8,0)+IF('2011 Actual'!L9="McSpadden",'2011 Actual'!M9,0)+IF('2011 Actual'!L10="McSpadden",'2011 Actual'!M10,0)+IF('2011 Actual'!L11="McSpadden",'2011 Actual'!M11,0)
|