Let me clarify:
I filled up rows 3-15 in each of the columns with values 1 through 12, and
the total I'm getting when using a test date of 1/4/2008 is only 10, not the
expected 12.

"JLatham" wrote:

Damn, that's sweet - but take a look at it a little close, I'm coming up
short 2 months. I filled each of the columns from 3 to 15 with increasing
values starting at 1, so for 12 months with date after 3rd, I'd expect to get
a total of 12 for that row, but I'm only getting 12. I put your formula into
both columns AJ and AL with the same results: 10 instead of the expected 12.
To test on out into the future I changed the formula to point to a cell with
a manually entered date instead of using TODAY() just to test this kind of
thing.

For my test date I used 1/4/2008 and just cannot get it to come up with
anything but 10 for those.

But yours takes care of the whole situation much better than my ugly beastie
in general - specifically the values in rows corresponding to days after
current day of the month.

"T. Valko" wrote:

Try this:

Row 1 = date headers

=SUMPRODUCT(--(MOD(COLUMN(AN3:IV3),6)=4),--(AN$1:IV$1<=TODAY()),AN3:IV3)

Adjust for the end of the range

Copy down as needed

Biff

"SJT" wrote in message
...
I think I'm in need of some type of index & match formula. I have column
headings that are dates and below them are a series of numbers. I would
like
a formula that adds the numbers below the column headings based on today's
date. For example, in column AN I have a column heading of 1/1/07 and
below
the column heading I have numerical data in rows 3 -15. In column AT I
have
the column heading 2/1/07 and in Column AZ, I have the column heading
3/1/07.
This continues in the same pattern for each month of the year and below
each
column heading is data in rows 3 - 15. I would like to add the cumulative
total of each row for each column depending on the date. Since today is
3/3,
for example I would like to add the total of Cells AT3 and AN3 in one cell
and then have a similar formula for each of the rows 4-15. On 4/1 this
formula would add to the previous totals the data in Column AZ rows 3 -
15.
Would appreciate any help you could provide. Thank you in advance for
your
assistance.