Have you tried making the criteria formula absolute?

1 January = SUMIF('Points - Branches'!B:B,Standings!$A$1,'Points -
Branches'!AN:AN)

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"dcd123" wrote:

>
> I am trying to sort by sumif results to no avail! I have a specific
> cell as the criteria and when I run the sort, it follows the contents
> 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 the
> Column A sorts properly, but the numbers in Column B stay as they are
> since if January moves to A3, the criteria in the B1 changes to A3
> automatically.
>
> I hope someone can help!!
>
> Thank you!
>
> dcd
>
>
> --
> dcd123
> ------------------------------------------------------------------------
> dcd123's Profile: http://www.excelforum.com/member.php...o&userid=25396
> View this thread: http://www.excelforum.com/showthread...hreadid=388692
>
>