Forum

Notifications
Clear all

Keep Original Formula Value After Sorting

4 Posts
3 Users
0 Reactions
46 Views
(@tenkenaid)
Posts: 2
New Member
Topic starter
 

Hi,

I would like the keep the values the same in rows 41 to 45 after doing a sort on column D highest to lowest.  Is there a way to do this?

Thank you.

 
Posted : 10/03/2021 1:02 pm
(@debaser)
Posts: 837
Member Moderator
 

I'd suggest you add a new column with the IT (and other) identifiers in it, and then use SUMIF formulas.

 
Posted : 10/03/2021 1:22 pm
(@tenkenaid)
Posts: 2
New Member
Topic starter
 

Thank you Velouria. 

That helped me figure out I could use this formula in row 41 and it keeps the value the same after sorting column D.

=SUM(SUMIF(A2:A37,{"ana","amp P","amp S","cto"},B2:B37))

 
Posted : 10/03/2021 1:47 pm
(@questvba)
Posts: 125
Estimable Member
 

Hi Kent,

Indeed, it is a good solution to use SUMIF but you will have a problem because you have two identical 'tco' identifiers (line 15 and line 24) and you want to treat them differently: you take into account the 24 in your DLEB sum but you don't take into account the 15.

BR,

Lionel

 
Posted : 11/03/2021 12:57 am
Share: