Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Adding Cell Values From One Worksheet To Another Worksheet

  1. #1
    Join Date
    7th March 2006
    Posts
    6

    Adding Cell Values From One Worksheet To Another Worksheet

    HELP:
    I am working with several worksheets in a file. The first sheet is going to be a "grand total" sheet. I want to accumulate numeric data in cell B10 on all other sheets to a total in cell C14 on the "grand total" (first) sheet.
    Can anybody help? P L E A S E???

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,716

    Re: Help: Adding Cell Values From One Worksheet To Another Worksheet

    Hi MrJay

    Welcome to ozgrid.

    Please read THIS PAGE IN FULL.

    You have use the superfluous word "Help" even though it states non the New Thread page not to. Please take more care in future.

    In regards to you question. In the cell on the Grand Total sheet type

    =SUM(

    Then use your mouse pointer to select the the first sheet, then select the needed Cell(s). Finally hold down the Shift key and click the last sheet and you should end up with a SUM formula

    =SUM(Sheet2:Sheet5!A1:A10)

  3. #3
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,314

    Re: Adding Cell Values From One Worksheet To Another Worksheet

    check these free examples, look at the Summary examole
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 1
    Last Post: June 12th, 2007, 01:32
  2. post cell values to worksheet
    By elrussell in forum EXCEL HELP
    Replies: 12
    Last Post: February 28th, 2006, 09:17
  3. Replies: 3
    Last Post: November 10th, 2004, 21:42
  4. Replies: 2
    Last Post: May 26th, 2004, 02:11
  5. Replies: 7
    Last Post: May 16th, 2003, 03:40

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
  •  
porno