Results 1 to 3 of 3

record the total items from each sheet in a column called All Totals

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    2

    record the total items from each sheet in a column called All Totals

    Hi everyone,
    I am a bit stuck with an excel spreadsheet I do for work and would like to ask your advise, I will try to explain as best as I can.
    I am running a small store that feeds 13 buildings.
    On the spreadsheet there are 13 sheets, one for each building.
    The items will go out monthly.
    What I need to do is record the total items from each sheet in a column called All Totals on the first sheet, this will add up the totals for all the buildings.
    If I put an attachment that may help out a bit.
    If you can look at P3 it is all the P3s to add together, next down will be total of P4,P5,P6...
    Good luck but if this can not be done it is not the end of the world.
    Reg
    Attached Files Attached Files
    Last edited by caretaker; 03-21-2009 at 02:37 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1