View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Auto Sum a Range of Cells based on the date

There are a few approaches

Using your posted data in A1:H2
and
If the first row of data contains actual dates that are the 1st of the month

Try this:
A3: =SUM(A2:INDEX(A2:H2,1,MATCH(TODAY(),A1:H1,1)))

Is that something you can work with?

Or.... if your data has a different structure, please share it.
***********
Regards,
Ron

XL2002, WinXP


"jcpotwor" wrote:

Hello,

I have a table with each column titled by the month, and in row 1 I have a
range of data. I would like to have a formula that automatically sums up the
range up to the current month without having to enter in a new formula any
month. Is this possible? I imagine it would require the TODAY() function
but after that I am lost.

Example:

Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07
1.0 2.0 2.0 2.0 1.0 1.0 1.0 2.0

Today I would want to add up the Nov-Jan colums to get (5), but next month
when I open the same spreadsheet I would like that same formula to add up the
Nov-Feb columns to get (7)
Thanks!
Joe