# Posts by BigWorm

• ## Formulas : Adding contents, and values

Hi Guys

I have an Excel sheet with a column of numbers, the cost of my items. example rows A1 to A400 have the value of my stock in them, I would like to add the numbers together, and come out with a total value of my stock.

Also I have column B1 to B400 and I have to add HIR to the contents inside all 400, with out any spaces in between example, B1 is 0441, B2 is 0442, B3 is 0443, I need B1 to be HIR0441, B2 to be HIR0442, and so on.

You guys have been great in the past, and have saved me days of screwing around !

Many Thanks
Big Worm

• ## [Solved] Formulas : Help with sums of 2 rows

Hi Andy

Your right I was not clear, It is a Column of 700 prices, C1 to C 700 the prices vary from cell to cell, I need to convert each price by 1.8 times, and come up with a new Column of converted prices.

Thanks for you help Bud.

Steve

Ps still trying.

• ## [Solved] Formulas : Help with sums of 2 rows

Hi guys

I been looking around the web for days for an answer,

I have an excel file of about 700 products, discriptions, and cost.

The problem is row C the cost is in Pounds, and I need to convert the whole row to US \$

So I need to multiply the entire row by 1.8

Is there a way of not having to enter a formula for the row ane cell at a time,

example C1 to C700 x 1.8 to D1 to D700.

Hope you guys understad what i need,
any help will be great

Thanks a Steve