vlookup to sum different columns....BUT....

[mart biesheuvel]

HELLO EXCEL fans & pro's

i have a have a matrix in a separate sheet a9:bb70 [where columns c9:bb9 are the 52 weeks of the year]
each row [9 to 70] represents totals [hours] of a particular project in any of the 52 weeks

i have another sheet where a user can select a period of time [start week]E3 and end week F3. say weeks: 1 to 4

my search function needs to search in the matrix for each project but ONLY summing the numbers given the variable period of time chosen [e3 and f3]

i can upload the 2 sheets though don't know how here.
yrs
mart

 

[Scott Huish]

=sum(index(c10:bb70,,e3):index(c10:bb70,,f3))

 

[mart biesheuvel]

=sum(index(c10:bb70,,e3):index(c10:bb70,,f3))

scott, thanks
but this formula returns the sum of all rows within the columns set by e3 and f3.
eg if e3 =[week]4 and f3 =[week]10 i want to pull the total per particular row within the c10:bb70 matrix

ie. a particular row = a particular project for which i need totals between, say, week 4 and 10 NOT
the totals of all projects [all rows] in period week 4 to 10

cheers

mart
[combine with a vlooup??]

 

[Scott Huish]

=sum(index(c10:bb70,,e3),index(c10:bb70,,f3))

This would be the sum of both columns, how are you indicating which row you want to sum?