Excel Problem

HOME Forums Tech Software Talk Excel Problem

This topic contains 2 replies, has 2 voices, and was last updated by Jukebox 4 weeks, 1 day ago.

  • Creator
  • #35827


    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
  • #35829

    Dave Rice
    Forumite Points: 2,686

    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



    Forumite Points: 577

    Brilliant! Many thanks Dave. John

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

You must be logged in to reply to this topic.