Trying to Sort - Can't change part of an array error

[Janet_M5670]

Hi, 

I linked some data with sumif formulas.  Now I want to sort the rows by job number and the color of backfill and I am receiving an error that states "You can't change part of an array."  Is there a work around?  

Thanks.

Janet

[#2]

@Janet_M5670 

Click a cell in the matrix. Press the F5 key. Select "Contents" - "Current Array".
Now you can either select "Cut" in the marked area with the right mouse button.
Or "Copy" - "Paste Special" - "Values".
Then you only have the constants in that area.

Formulas should of course be insured beforehand and then copied back again.

I hope I understood the question correctly.

* It is always helpful if you always indicate the operating system and Excel version of your topic, so that you come to a faster and more precise solution proposal.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

[#3]

@Janet_M5670 

Janet, you can't apply SORT or modify somehow else part of the spill array/range, you need to modify entire formula. That's hard to say anything more concrete without the sample of the formula.