Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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:
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I apply conditional formating for cells in different file. | Excel Discussion (Misc queries) | |||
modify a macro to apply to a specific range of cells | Excel Discussion (Misc queries) | |||
How to apply conditional formatting on group of cells by using dat | Excel Discussion (Misc queries) | |||
How do i a apply range(autoformat) in non-adjacent cells? | New Users to Excel | |||
How to apply rounding across a range of cells with other formulae | Excel Worksheet Functions |