View original (French)

Descending sort impossible with SUMIFS

Maxime -  
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   -

Hello,

I am currently facing a problem regarding sorting in Excel.

I have been trying for several days to sort data in descending order that comes from a SUMIFS formula.

My sorting seems random, I have tried to find a solution, especially by making sure the format is set to "Number". It doesn't work. I also integrated a "CNUM" to automatically convert to number. Same effect....

If you know how I could perform this sorting, I would be grateful, thank you!

1 answer

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     

    Hello everyone,

    when you sort, you sort the values, not the formulas

    for example, if in b3 you have =a2; if you sort column A, the value of a2 will change, and necessarily that of b3 will too.

    you need to copy/paste the values from your table and there, you can sort


    Best regards

    1