Thread
:
There's Got to be an Easier Way
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
There's Got to be an Easier Way
Try:
=SUM(INDIRECT("K13:"&CHAR(74+$D$2)&"13"))
--
HTH
Sandy
with @tiscali.co.uk
"Sprint54" wrote in message
...
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
Reply With Quote