Hello, I am a wholesaler and have received an inventory spreadsheet with pricing for products from my Distributor, in order for me to send the sheet to my retailers, I first need to update the prices of each product to add my markup so if I should need to add $3 to every item's pricing, is there a way I can add the $3 to EVERY product's existing pricing and have th sheet updated to reflect MY pricing please?

=sum(A1+3)

Where A1 is the suppliers price

sorry, I'm not all that familiar with spreadsheet editing, under "Auto sum" when clicking on the "Formulas" tab, in the dropdown menu which appears when I click on the arrow on the Auto Sum tab I click the SUM option, this shows some numbers showing up elsewhere in the sheet? I have 2 pricing in the original sheet, the wholesale pricing I am getting from my distributor when ordering more than 48+ pcs, this is under Column D and the pricing for any amount less than 48 pcs in column E, help?

If you attach the sheet I could have a look for you. I'll try to help you.

If you open a new spread sheet and type 3 in cell A1 and in cell B1 type =sum(A1+3) it will calculate it for you, then it's a case of copying the formulae down the page to replicate it to all the stock.

That is still baffling me, I'll try to attach the sheet here

Attached Files

Eddies 11-26 p - Copy.xls (180.0 KB, 12 views)

No need for fancy formulas or whatever
Enter the value 3 in any empty cell and copy it
Select the range(s) where you need the value added (entire range(s) adjacent or not)
Right click and click Paste Special
Select Add under the Operation header - Ok - Done

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I highlighted the entire E column, right click on it then a new small window opens, the attached shot is what I am seeing?

Attached Images

Untitled.jpg (112.6 KB, 12 views)

Did you copy value 3 in an empty cell somewhere in the same sheet?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

yes, it turned into 3.00

Did you copy (or cut - either works) the 3 after inputting it?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

yes I did copy the 3.00 then selected the entire E column, right click in it then chose "Paste Special" and that's when the new window opens BUT I closed the sheet re-opened it tried your instructions again and this time when I right click and Paste Special another smaller window opened and I see the option to choose ADD so it workds now, thank you very much guys!