• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sort by Rows when Columns contain Formulas

C

Callie

New Member
Hello,

My work team would like to be able to sort a file that we all use.

I have come up with a different formula that uses SUMIFS, but they would rather be able to trace the cell precedents that make up the formula, so my solution won't work for them.

Is there a way our data can be sorted and maintain the same results in the formulas? I have attached a file with a simplified example.

Thank you in advance.
 

Attachments

  • Sort Data with Formulas.xlsx
    10.1 KB · Views: 5
Try,

Change your H19:H21 formula into :

[H19]: =SUMIF(G$7:G$21,"Payroll",H$7:H$21)*1.3

[H20]: =SUMIF(G$7:G$21,"Payroll",H$7:H$21)*1.06

[H21]: =SUMIF(G$7:G$21,"Payroll",H$7:H$21)*1.08

Then, do the sorting

Regards
Bosco
 
Thank you for looking at this. I have done something similar using SUMIFS, but the team wants to see exactly which cells are being referenced. So I was hoping to still use the original formula and ask if there was any way to alter it so that it references the same cells before and after we sort the data.
 
Sorry, I believe sorting and the traditional 'click and pray' style of referencing are mutually incompatible. @Bosco's solution is about as good as you are going to get.
 
You must log in or register to reply here.
Back
Top