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