| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Use TREND function with nonadjacent cells
I am trying to use the TREND function with nonadjacent cells, but doesn't
works! For example: I have a column with diferents rows for months (cells C1:C12) and a total at the end of the 2004 year (cell C13) After that, I have more rows for months of the 2005 year (cells C14:C25) and their total (cell C26) When I try to get the trend of months Oct'04-Nov'04-Dic'04-Jan'05-Feb'05-Mar'05 (last 6 months) I can't select the range C10:C16 because the total cell (C13) is included. When I select the range with nonadjacent cells, Excel show me an error. Someone could help me? Thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with adding certain cells using an IF function | Excel Worksheet Functions | |||
| multi function cells | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| I cannot select nonadjacent cells in Excell Office XP SP2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
