+ Reply to Thread
Results 1 to 10 of 10

excel worksheet defined sums

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    excel worksheet defined sums

    http://www.mrexcel.com/forum/excel-q...%2A%2A%2A.html


    THIS IS WHAT I AM LOOKING FOR. ANY HELP WOULD BE APPRECIATED!

    I want to be able to have an excel summary sheet and multiple sheets of info. I want a user to be able to type ANY two sheets in the workbook......for example......... A: Sheet1 B:Sheet4........... I want the the SUM of a certain cell between those sheets to show in a total cell. I HAVE ATTACHED EXACTLY WHAT I AM LOOKING FOR THANKS!
    Attached Files Attached Files
    Last edited by zbor; 06-17-2014 at 09:11 AM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: ****excel worksheet defined sums******

    Welcome to the forum.

    Please take a few minutes to read the forum rules about cross-posting.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    Re: ****excel worksheet defined sums******

    Thanks for the heads up. New to forums.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,070

    Re: ****excel worksheet defined sums******

    Hi and welcome to the forum

    Reasons this is not working for you...
    1. Your formula points to A2:A4 which is empty
    2. You are trying to reference A and B, but your sheet names are Sheet1 and Sheet2
    3. I dont this the "=SUMPRODUCT(SUMIF(INDIRECT( " works this way/

    If you just want to sum 2 sheets, then maybe this...
    =SUM(INDIRECT("'sheet"&C2&"'!H2:H5"))+SUM(INDIRECT("'sheet"&C4&"'!H2:H5"))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    Re: ****excel worksheet defined sums******

    I tried that and I am getting a #REF Error. I want Cell H5 between whatever sheets I type in to SUM for me. I have attached picture. Excel Pic.PNG

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,070

    Re: ****excel worksheet defined sums******

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

  7. #7
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    Re: ****excel worksheet defined sums******

    Cross-linked.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,070

    Re: ****excel worksheet defined sums******

    Thanks, see post #4

  9. #9
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    Re: ****excel worksheet defined sums******

    I tried that and I am getting a #REF Error. I want Cell H5 between whatever sheets I type in to SUM for me. I have attached picture. Excel Pic.PNG

  10. #10
    Registered User
    Join Date
    06-16-2014
    Location
    United States
    MS-Off Ver
    2013
    Posts
    72

    Re: ****excel worksheet defined sums******

    Here is what it is saying to me Capture.PNG

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pull Data from Excel Worksheet to Another Based on Defined Values
    By HjMcLean in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2013, 02:31 PM
  2. [SOLVED] Application-defined or object-defined error (worksheet, range, sel
    By darxoul in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-02-2006, 09:05 AM
  3. Error messages from user defined Excel worksheet function
    By Helge V. Larsen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-18-2006, 12:35 PM
  4. Link sums from worksheet to worksheet
    By Mark G. in forum Excel General
    Replies: 3
    Last Post: 01-09-2006, 07:10 AM
  5. [SOLVED] Can a defined name be used in the header of a worksheet in Excel?
    By Shapirotwin1 in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM

Tags for this Thread

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