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

    Quote

    Originally posted by BigWorm
    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.


    Big Worm


    Might have missed your point (brain not working) but do you need the SUM function???


    Edit: like A401=SUM(A1:A400) ?

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

    Assming the values in column B are text rather than formated numbers, put the following formula in C1 and drag down.
    ="HIR"&B1
    If desired you could then copy the C results and using Paste Special as Values replace the B values and then delete the C values.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login