+ Reply to Thread
Results 1 to 9 of 9

sum formula for same cell on multiple tabs

Hybrid View

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    Charleston SC
    MS-Off Ver
    MS 365 Apps for business
    Posts
    30

    sum formula for same cell on multiple tabs

    I'm wanting to add the value of B3 from each of 30 consecutive tabs, totaled on Tab 31. Is there a simple, shorthand way of expressing that, or do i have to add each one in a long string? Many thanks!

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,769

    Re: sum formula for same cell on multiple tabs

    You can use something like
    Formula: copy to clipboard
    =SUM(Sheet1:Sheet30!B3)

  3. #3
    Registered User
    Join Date
    03-07-2022
    Location
    Charleston SC
    MS-Off Ver
    MS 365 Apps for business
    Posts
    30

    Re: sum formula for same cell on multiple tabs

    That was the first thing i tried, but it's not working, with our without parentheses around the sheet names.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,769

    Re: sum formula for same cell on multiple tabs

    In that case can you provide a sample workbook.

  5. #5
    Registered User
    Join Date
    03-07-2022
    Location
    Charleston SC
    MS-Off Ver
    MS 365 Apps for business
    Posts
    30

    Re: sum formula for same cell on multiple tabs

    Attached is the book, thanks!
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,824

    Re: sum formula for same cell on multiple tabs

    this

    in B3

    =SUM('1:31'!B3)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,769

    Re: sum formula for same cell on multiple tabs

    Thanks for that.
    It should be
    Formula: copy to clipboard
    =SUM('1:31'!B3)

  8. #8
    Registered User
    Join Date
    03-07-2022
    Location
    Charleston SC
    MS-Off Ver
    MS 365 Apps for business
    Posts
    30

    Re: sum formula for same cell on multiple tabs

    That did it, thanks so much!

  9. #9
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,769

    Re: sum formula for same cell on multiple tabs

    Glad to help & thanks for the feedback.

+ 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. [SOLVED] Formula for totals across multiple tabs
    By Ramenmole in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 08-09-2022, 11:15 AM
  2. [SOLVED] Help with sumifs formula across multiple tabs
    By hmcarter2007 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2017, 10:53 PM
  3. [SOLVED] Help with a formula across multiple tabs of data
    By tabled in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2017, 05:09 PM
  4. [SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2015, 07:42 AM
  5. [SOLVED] IF/AND Formula in Multiple Tabs
    By quibilty in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 05-24-2014, 06:26 PM
  6. Formula help with multiple tabs
    By f150crewcab in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-10-2013, 04:52 PM
  7. Same cell from Multiple tabs
    By Gallinski in forum Excel General
    Replies: 9
    Last Post: 06-01-2010, 02:42 AM

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