Sum of stats in two seperate excel files updated weekly

Hi I am very confused and hope someone here can help me, I have two websites in which I receive weekly (soon to be daily) stat reports for the players on the site (it is a gambling website). Every time I get a new report I have to manually go down each column for each player stat and add them together individually. As you can imagine this is very time consuming, how could I automate this to where I could load the latest stat report up and it would add the values to the current values (stats) for each different stat for each separate player? Thanks.

hello,

you could try using sumproduct and indirect together, attached is an example, it takes the stats on one sheet and compiles them, as you add more stats, it recalculates the new data without having to change the formulas.

hoep it helps reg

thank you, I will mess around with it. What exactly do I have to do with the new sheet every time I get a new one? Do I copy and paste it into the first tab (input sheet)? I have attached two of these sheets to this post to help give you an idea of what I need to do.

Hi and welcome to the board,
unfortunately, no files attached !
Use the "file management" button on the thread answering form to upload your examples

Ooops here they are

I don't quite understand that spreadsheet, all I am trying to do is add the the two sheets I just uploaded together (each individual field) and then every time I get a new one have somewhere or some way to add the values in the new sheet to the one I already have. In the one you gave me there is a counta field and a static field...not quite sure what those are. Thanks.

hi miamiking75,

I have taken your excel sheets and created an example, there is an input sheet( just cut and paste the data into it) and a results sheets, this sumproducts the results using INDIRECT, so no having to adjust formulas.

if it needs a little more explaining let me know.

thanks reg