| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
There's Got to be an Easier Way
How could this formula be simplified?
=IF($D$2=1,K13,IF($D$2=2,SUM(K13:L13),IF($D$2=3, SUM(K13:M13),IF($D$2=4,SUM(K13:N13),IF($D$2=5,SU M(K13:O13),IF($D$2=6,SUM(K13:P13),0)))))) It's purpose is to total monthly numbers for a YTD total based on the current month. In cell D2 is the current month number (1 for Jan, 2 for Feb, etc..) The monthly actuals are located in cells K13 through V13. The formula is entered in cell I13. The idea is that each new month the monthly indicator in cell D2 is updated to reflect the current month. I then want the new YTD number to be summed in cell I13. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an easier way? | Excel Discussion (Misc queries) | |||
| Procedure to make a dropdown list larger so it's easier to read | Excel Discussion (Misc queries) | |||
| Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
| Trying to enlarge tab size on worksheet for easier reading | Excel Discussion (Misc queries) | |||
| Excel Hyperlink: Is there an easier way to follow then double-cli. | Excel Discussion (Misc queries) | |||
Threaded Mode
