Conditional SUM of column values depending on the heading (month)
 

Hey all you EXCEL wizards! Can you please help?

I'm collecting performance metrics by month, each metric in a row. I'd like
to put a cell in the top of the page that would allow the user to pick the
month from a validation list that is tied to the column headings (month names
in row 5, columns J through U).

When the user defines what month it is by choosing from the list, I would
like a "year to date" column to add the correct number of columns for a YTD
total, i.e. if March were chosen, the sum of J, K, and L would be shown in
the YTD cell.

Any ideas? Thanks for the help.
--
Pat Rob

Conditional SUM of column values depending on the heading (month)
 

Use Match to find the matching month and offset to define the range...
Something like this... Not it adds the first 10,000 rows. Set the value to
suit...

=SUM(OFFSET($J$6,0,0,10000,MATCH($B$1, $J$5:$U$5, 0)))
--
HTH...

Jim Thomlinson


"Pat Rob" wrote:

Hey all you EXCEL wizards! Can you please help?

I'm collecting performance metrics by month, each metric in a row. I'd like
to put a cell in the top of the page that would allow the user to pick the
month from a validation list that is tied to the column headings (month names
in row 5, columns J through U).

When the user defines what month it is by choosing from the list, I would
like a "year to date" column to add the correct number of columns for a YTD
total, i.e. if March were chosen, the sum of J, K, and L would be shown in
the YTD cell.

Any ideas? Thanks for the help.
--
Pat Rob