If you are attempting to change the sell, unit sell total, or sell total and are unable to do so you may have SELL prices locked.
While in the project spreadsheet look at the column for SELL and click on lock icon.
This will lock or unlock sell price.
This can also be done in the “Project Details Panel” in the Totals section.
Once you unlock the SELL prices you can make changes to the sell prices.
Please review the attached snapshot for more details.