Formula to lookup and sum data on different sheets

[nbrp]

I am looking for a formula that will add some numbers for me on different sheets based on a sorted option that I choose on my Summary tab. sample survey (1).xlsx Here is a sample workbook with what I am looking for. Thanks for the help.

[FDibbins]

Looking at your file, I cant see which info would be for I1 and which for I1? Perhaps if you included a few sample answers\?

Also, if you use the same layout on all sheets, you could probably use a simple SUM() function.

[bryanr72]

Sorry....replied to the wrong thread.

[nbrp]

I have sample answers in the Day 1, 2, and 3 sheets but I left the Summary tab as is since I wanted to change the formulas. The data will not be different for either instructor on day 1 since they both teach that day. Basically I want to be able to see how each instructor has done at the end of the year. They will all have different numbers on the summary page since they do not all teach on the same days.

The sum function alone would not work since I wanted to be able to use either a drop down list or just type in a name and have that specific persons scores show up on the summary tab.