how to apply conditional formula over large range of cells
 

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)

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
--------------------------------------------------------------------------