I know it's a long formula, but looks like the most simple way is to just:
=VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,99,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,100,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,101,FALSE)+VLOOKUP(A162,'Raw
Data'!$A$5:$CY$211,102,FALSE)+VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,103,FALSE)

-Simon


"nejohnso76" wrote:

> Hi All,
> I have a 2 worksheets, 1 of which contains a lot of raw data and the
> other is a summary view of the raw data. The raw data is broken down
> by week so there are multiple columns per month but the summary
> worksheet is summed by month. Is it possible to use a vlookup to find
> an item number in a column but specify a range of columns to sum [ex.
> =VLOOKUP(A162,'Raw Data'!$A$5:$CY$211,99,FALSE)] instead of just
> looking in column 99 I'd like to sum the data in 99 thru 103. Any
> suggestions?
> Thanks!
>
>