Re: Index & Match

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <SJT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BD9330C2-B01E-4216-942D-C2EB3627DCD8@xxxxxxxxxxxxxxxx
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.


.

Quantcast