Forum Discussion
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 Help
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
7 Replies
Hi Paco
Try this?
(insert into E5 and drag the formula down using Autofill)
=SUM(G5:Column#)Screen shot is below. Sample file is attached with the formula.
Hopefully I understand you right?
If you want to retain the references, just add $ in front of the column letter and row number (e.g. $G$5:$K$5).
Let me know if this suits or whether we need to dig a bit further?
Cheers
Damien
Hi !
Thanks for the answer but I'm still at the same point.
Let me share you this screen shots maybe you could see my problem.
I've just downloaded the file and it has the same issue, I click on the filter to organize from the top tu bottob scorer and it happens the same. The names and team get organized but the numbers stays..!!!
