Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In column A I have Month, Jan, Feb, €¦.Dec.
In column B I have Heading Year 2003 with data for each month. In column C I have Year 2004, with data In column D I have Year 2005, with data until April In column E I would like Sum for Last 12 months. So cell E2 would be Sum(C3:C13)+Sum(D2) Cell E3 would be Sum(C4:C13)+Sum(D2:D3) But this needs adjustment if I wish to pull in down the full column E. Is there a formula I can pull down which allows me to sum only the last 12 months for which I have data? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |