Forum Discussion

Copper Contributor

Feb 11, 2018

Solved

Sum with reference

I need to sum the cells from right table into the left one and be able to order the left one as I want without losing the reference

excel

Excel Online

Formulas and Functions

office 365

Damien_Rosario
Feb 13, 2018
Hi Paco

You should be able to apply the filters by turning them off, and then back on again, which will go across all the Headers in row 3, and it should not affect the set up that I have suggested.

Feel free to use the document I have provided my friend, it's for you after all!

So you know, the issue was that the headers were not lined up in the same row (3) so when you sorted your Goles Largest to Smallest, it didn't include J1, J2, etc. Now it will sort everything.

Please let us know if you require anything further.

If this has resolved your question, please mark the solution posted as Best Response so that other visitors will know the solution.

Best of luck friend!

Cheers

Damien

paco rueda de l

Copper Contributor

Feb 13, 2018

I could try to put the filters but I don't want the error message again and screw it up so...

Damien_Rosario

Silver Contributor

Feb 13, 2018

Hi Paco

You should be able to apply the filters by turning them off, and then back on again, which will go across all the Headers in row 3, and it should not affect the set up that I have suggested.

Feel free to use the document I have provided my friend, it's for you after all!

So you know, the issue was that the headers were not lined up in the same row (3) so when you sorted your Goles Largest to Smallest, it didn't include J1, J2, etc. Now it will sort everything.

Please let us know if you require anything further.

If this has resolved your question, please mark the solution posted as Best Response so that other visitors will know the solution.

Best of luck friend!

Cheers

Damien

paco rueda de l
Copper Contributor
Feb 13, 2018
You just did it!! You're the best Damien. Thanks a lot!!!