Forum Discussion
MrsD06
Feb 03, 2020Copper Contributor
Help With SUM in Excel
I have a CSV file with a column with different prices in it and i want to add 5 to all the prices. What is the sum to do that and how do i do it? Any help greatly appreciated 🙂
SergeiBaklan
Feb 03, 2020Diamond Contributor
As variant, if that's one time job, for such example
select and copy cell C1, after that select numbers in column A, Paste->Paste Special->Add->Ok
Result is
MrsD06
Feb 03, 2020Copper Contributor
Perfect thank you. I have been trying to find this out for ages 🙂
- SergeiBaklanFeb 03, 2020Diamond Contributor
MrsD06 , you are welcome