D
dcd123
I am trying to sort by sumif results to no avail! I have a specifi
cell as the criteria and when I run the sort, it follows the content
of the cell specified. Is the task I wish to complete even possible??
Here is an example:
Column A Column B
1 January =SUMIF('Points - Branches'!B:B,Standings!A1
'Points -
Branches'!AN:AN)
2 February =SUMIF('Points - Branches'!B:B,Standings!A2
'Points -
Branches'!AN:AN)
3 March =SUMIF('Points - Branches'!B:B,Standings!A3
'Points -
Branches'!AN:AN)
I am trying to do a decensing sort by Column B and what happens is th
Column A sorts properly, but the numbers in Column B stay as they ar
since if January moves to A3, the criteria in the B1 changes to A
automatically.
I hope someone can help!!
Thank you!
dc
cell as the criteria and when I run the sort, it follows the content
of the cell specified. Is the task I wish to complete even possible??
Here is an example:
Column A Column B
1 January =SUMIF('Points - Branches'!B:B,Standings!A1
'Points -
Branches'!AN:AN)
2 February =SUMIF('Points - Branches'!B:B,Standings!A2
'Points -
Branches'!AN:AN)
3 March =SUMIF('Points - Branches'!B:B,Standings!A3
'Points -
Branches'!AN:AN)
I am trying to do a decensing sort by Column B and what happens is th
Column A sorts properly, but the numbers in Column B stay as they ar
since if January moves to A3, the criteria in the B1 changes to A
automatically.
I hope someone can help!!
Thank you!
dc