Cell Reference After Sorting

Hi mattlandry,

Welcome to the forum!!

Naming the range (i.e. cell B16 in this case) should do the trick. To do this follow these four steps:

1. Ensure your cursor is on the desired tab and cell for the criteria part of the SUMIF function to reference
2. Press Ctrl + F3 to display the Define Name dialog
3. In the Names in workbook textbox, enter a name for the range say: SumIfCriteriaValue
4. Click OK

You can now reference the value held in the range defined in step 3 above (regardless if its position changes) as you would any other cell, i.e.

=SumIfCriteriaValue or as part of your original formula;
=SUMIF('MONTHLY REPORT'!$A$2:$A$59999,SumIfCriteriaValue,'MONTHLY REPORT'!$F$2:$F$59999)

HTH

Robert

Thanks for letting us know and you're welcome

If you could mark the thread as closed, it would be appreciated.