View Single Post
  #1   Report Post  
macasst macasst is offline
Junior Member
 
Posts: 1
Question 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)