Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
4
Views
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
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
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
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
