+ Reply to Thread
Results 1 to 2 of 2

SUM cell values across multiple identical tables

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    SUM cell values across multiple identical tables

    I have a list of excel table names (each table layout is identical) and I want to write a formula within another identically formatted table that will return the sum of each table's value in that corresponding cell. The list of table names will be in its own range. The tables listed can change and the total number of listed tables can also change. What's the best way to go about accomplishing this? Preferably formula and not VBA.

    Thank you,
    kb

  2. #2
    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
    28,206

    Re: SUM cell values across multiple identical tables

    Please see the yellow banner at top of the page with instructions on how to attach a sample workbook.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 6
    Last Post: 03-24-2022, 06:25 AM
  2. Replies: 1
    Last Post: 07-23-2019, 05:50 PM
  3. Replies: 1
    Last Post: 10-30-2018, 07:38 PM
  4. Adding Multiple Identical tables to a Master Identical table
    By dlogfx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2017, 04:41 PM
  5. Replies: 0
    Last Post: 03-10-2014, 03:38 PM
  6. Link multiple, identical graphs to multiple data tables
    By HJII in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-05-2014, 10:02 AM
  7. [SOLVED] Add multiple identical values in one cell - VLOOKUP
    By nigo75 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 05:01 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