Help With SUM in Excel

Question

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?&nbsp;Any help greatly appreciated 🙂

sergeibaklan · Answer

MrsD06&nbsp;
As variant, if that's one time job, for such example

select and copy cell C1, after that select numbers in column A, Paste-&gt;Paste Special-&gt;Add-&gt;Ok

Result is

mrsd06 · Answer

SergeiBaklan&nbsp;Perfect thank you. I have been trying to find this out for ages 🙂

sergeibaklan · Answer

MrsD06&nbsp;, you are welcome

abiola1 · Answer

Just posted a blog on thishttps://www.exceljetconsult.com.ng/home/blog/non-contiguous-columns-values-addition-using-paste-special/

Forum Discussion

Help With SUM in Excel

4 Replies