Extracting Specific Data from a Table

[derbycityroller]

I have a table with 6 columns of data. Column A is "Week" referring to the different weeks of the year (1-52). So I could have anywhere from 1-20 rows with column A of the row being the same number (ex. Rows 1-20 Column A would equal week 30 Rows 21-30 would equal week 31). If i wanted to setup a formula where it summed the values in column E of only the rows where its column A equaled the specified week (ex. 29) how would I do that? I can get VLookup to reference 1 row, but I do not know how to get it to reference an array of rows that equal the specified week. Any help is appreciated!! THANKS

Justin

 

[mfexcel]

SUMIF should be the function you need.

If i wanted to setup a formula where it summed the values in column E of only the rows where its column A equaled the specified week (ex. 29) how would I do that?
Justin