Groups

    Excel help needed please.

    I have to find the formula for the fields in B2 and B5 to add up and place the resulting sum in B32.

    This may be easy but im just not seing it, anyone know how?

    4 Comments

    Enter this into B32: =SUM(B2+B5)

    .. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)

    oldmanhouse;8221094

    Enter this into B32: =SUM(B2+B5).. if I'm reading your question … Enter this into B32: =SUM(B2+B5).. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)



    What he said...

    Original Poster

    oldmanhouse;8221094

    Enter this into B32: =SUM(B2+B5).. if I'm reading your question … Enter this into B32: =SUM(B2+B5).. if I'm reading your question correctly. The above will take the value in B2, add it to the value in B5 and then put the result wherever you put the formula (so put the formula in B32)



    Thanks worked a treat and learned something in the process. repped.

    Technically you don't need to put SUM or the ();

    It will work just as fine with =B2+B5 typed into cell B32
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. WIN AN UNFORGETTABLE TRIP TO SAN FRANCISCO11
      2. LG G6 International [email protected] droidauthority22
      3. Win a luxury eight-night break for two in Malaysia with Ushvani Spa and Tra…77
      4. mail on sunday comp - win a £3,000 thomas cook gift e-card33

      See more discussions