Sum of values from lookup in several sheets

[mroozendaal]

Hello,

I am new to this forum. I am hoping someone could help me with the following problem. I am building a workbook for keeping track of results from several sport events throughout the year. Each event will have its own sheet. Each sheet will contain the times, finishplace and points earned during that event. I would like an overview sheet that will show me the total of points each person has earned throughout the year in the different events. Another thing is that only the personś 6 best results will count towards the final ranking.

Doen anyone have an idea how to do this in Excel? I have already tried an array formula to lookup a valua on a single criteria (the participant's name) across multiple sheets. The problem is that this only gives me 1 value and not the total of points earned in all events combined and secondly it does not take into account that only the 6 best results should count.

Thanks. Probably easy for someone with a lot of excel knowledge, but too hard for me.

Thanks.

[bluesky63]

download Power Query Add-on to install in your Excel 2010

if all your worksheets are same layout and structure, you can consider using Power Query to transform it to what you desire, almost no coding require (provided your entry sheets are quite structure and best in table forms)

you can upload a sample of 2-3 mock up worksheets and also the output results that you want

Rgds