Formula to Sum values of specific people from multiple sheets into a single sheet

Hi.

In the example attached, I have 4 Sheets: 2013, 2014, 2015 and RESULTS.

I want to sumarize the data from 2013, 2014 and 2015 into RESULTS.

The Drivers are always listed on B2 onwards... and I want to add the values in C2, D2 etc for that specific driver. Example, column C will be the sum of that driver races, column D will be the sum of that driver starts etc... (disregard that the sum of Average data will be wrong, I will deal with that later).

The Drivers may have raced in one season or multiple season, I don´t know if this matters.

Do I use sumproduct for this ?

Thank you!

most columns are ok, only the total there is a use of . and ,



Kind regards
Leo

Originally Posted by LeoTaxi

most columns are ok, only the total there is a use of . and ,



Kind regards
Leo

Leo, thanks for the help. However, I noticed that only the drivers that Raced in 2013 are accounted for. 2014 and 2015 there were new drivers. Is there a way to list all the drivers from all the years?

Thank you !

yes you can copy the formula down and put more drivers
i think the formulas are there til row 20 but there is no limit (yes the row limit from excel )


kind regards
Leo

so here all drivers, only Karl-Günther Bechem[5], (2 times in 2015 with other results)
only 1 tme in result


Kind regards
Leo

Originally Posted by LeoTaxi

so here all drivers, only Karl-Günther Bechem[5], (2 times in 2015 with other results)
only 1 tme in result


Kind regards
Leo

Thank You kind sir. Is there any way to populate the drivers list in "results" automatically? Let's suppose I add a line in 2015 with a new driver, since the year hasn't finished it yet. Just to make things easier.

Thank you again.

so is don in this one , not only for 2015 but for all sheets
as long as the sheetname is different as RESULTS


Kind regards
Leo

Originally Posted by LeoTaxi

so is don in this one , not only for 2015 but for all sheets
as long as the sheetname is different as RESULTS


Kind regards
Leo

Leo,

It is working, If I enter the name manually on the 2013 or 2014 or 2015 list... I usually PASTE from another file... and it´s not working when I paste. Only if I type in manually.. or select the pasted name and select it and press enter. The volume is kinda big to do this manually.

Another question.. if I create a 2016 later... I just add the red part?

=IFERROR(VLOOKUP($B2;'2013'!$B:$U;COLUMN()-1;FALSE);0)+IFERROR(VLOOKUP($B2;'2014'!$B:$U;COLUMN()-1;FALSE);0)+IFERROR(VLOOKUP($B2;'2015'!$B:$U;COLUMN()-1;FALSE);0)+IFERROR(VLOOKUP($B2;'2016'!$B:$U;COLUMN()-1;FALSE);0)

Thank you !

that is right for most columns, a few columns the formula is longer

I see for a code that handle the names if u paste, later this day.

Kind regards

Hello,

not sure if this is the right result, but see after paste, run de code
and let me know


Kind regards
Leo