Use TREND function with nonadjacent cells

B

BonesCCS

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF argument limit - how convert formula to VBA? 2
index and sum nonadjacent cells 10
functions with nonadjacent cells 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Need Help with a VBA subroutine 0
countifs Function not giving desired result with date criteria 2
YTD SUMIF based on current date 3
Payment calculation 1

Top