Jim, Thanks for the formula, but I can't seem to get it to work. I reposted
this question as a new question (Lookup and Calculate Formula) and I'll post
your answer there. (It seemed to need its own question as it went beyond the
scope of my original question.)

"Jim Rech" wrote:

Thanks, David, for pointing out that I ignored months past December.

Karen, play with something like this:

=SUM(OFFSET(indirect(vlookup(...)),0,0,1,MOD(A1-4,12)))

Use VLOOKUP to get the name of the range and INDIRECT to make Excel find the
range with that name.

--
Jim
"Karin" wrote in message
...
| Thank you. Now let's get more complex. Is there anyway to return this
| formula in a Vlookup? I'm looking up a name in the range YTD, then I want
to
| do this formula for the row that the name is in.
|
| "Jim Rech" wrote:
|
| =SUM(OFFSET(E5,0,0,1,A1-4))
|
| --
| Jim
| "Karin" wrote in message
| ...
| |I made a slight change (Cell A1 is now a hard coded number, not a date
| | formatted to look like a number).
| |
| | "Karin" wrote:
| |
| | I have columns 5-16 (E:P) filled with monthly data.
| | Column 5 (E) contains May, column 6 (F) June, etc.
| | In Cell A1 I have the current month (7 for July, 8 for Aug, etc.).
| |
| | I want to sum cells E5 through ?5 based on the number in cell A1.
| | For July the sum would be E5:G5, for August it would be E5:H5, etc.)
| | What fomula would I use to create the sum based on the data in cell
A1?
| | TIA!
|
|
|