Forumite

Excel Problem

HOME Forums Tech Software Talk Excel Problem

This topic contains 2 replies, has 2 voices, and was last updated by Jukebox 3 months, 3 weeks ago.

  • Creator
    Topic
  • #35827

    Jukebox
    Participant
    @jukebox

    Can anyone help me please? I am setting up a workbook to list and estimate the value of my house contents for insurance purposes. I have made a sheet for each room/area and on each sheet add up the total value for that room into cell E1. It there any way I can now automatically add all the E1 values onto another Sheet?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Author
    Replies
  • #35829

    Dave Rice
    Moderator
    @ricedg
    Forumite Points: 4,209

    Yes, in the cell and sheet where you want the answer to be, start a formula by typing “=”. Now navigate to the first cell, click on it then press “+”. Keep doing that for all the sheets then press “Enter”.

    You will end up with a formula that looks like this: =Sheet1!E1+Sheet2!E1+Sheet3!E1

     

    0
    0
    #35833

    Jukebox
    Participant
    @jukebox
    Forumite Points: 725

    Brilliant! Many thanks Dave. John

    0
    0
Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Thank you for visiting Forumite. If you appreciate the site please consider a donation to show your appreciation.
Take Me There!