Excel Problem

Forumite Members › General Topics › Tech › Software Talk › Excel Problem

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • August 24, 2019 at 12:31 pm #35827
    JukeboxJukebox
    Participant
      @jukebox
      Forumite Points: 4

      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?

      August 24, 2019 at 1:55 pm #35829
      Dave RiceDave Rice
      Participant
        @ricedg
        Forumite Points: 7

        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

         

        August 24, 2019 at 3:09 pm #35833
        JukeboxJukebox
        Participant
          @jukebox
          Forumite Points: 4

          Brilliant! Many thanks Dave. John

        • Author
          Posts
        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.