Excel formula

Closed - This job posting has been filled and work has been completed.

Job Description

I need to aggregate statistical information from one worksheet into another worksheet.

Basically, in one worksheet right now, I have people's names, and statistical information next to these people's names. In that same worksheet, I have those same people's names with relevant statistical information across 10+ different scenarios.

Ultimately, I want to aggregate the statistics per each person, across those 10+ scenarios, in one "Summary" Excel worksheet. I feel like that is pretty easy with certain IF commands, but it will probably take me longer than it should.