Results 1 to 18 of 18

Adding numbers from an array into a single cell

Threaded View

  1. #17
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Adding numbers from an array into a single cell

    If Im reading you correctly then you dont necessarily know how many tables you're going to have and therefore cant just do a standard sum, if so then you could just use SUMIF

    eg to get the total of the column G entries use the formula:

    =SUMIF(B:B,"Benefits",G:G)
    Which basically sums the items in column G whenever theres the word "Benefits" in column B

    EDIT: To ensure your "totals" table isnt included slightly change the word Benefits in that table you could even add a trailing space or Underscore.
    Last edited by pjwhitfield; 09-26-2016 at 05:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 10-16-2013, 10:21 PM
  2. Adding multiple numbers within a single cell
    By Jmac1961 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2013, 02:19 PM
  3. [SOLVED] Adding 2 numbers from a single cell
    By tom hatten in forum Excel General
    Replies: 2
    Last Post: 08-18-2012, 09:24 AM
  4. adding numbers in a single cell
    By mmurrhee in forum Excel General
    Replies: 10
    Last Post: 03-31-2009, 03:39 PM
  5. adding numbers in a single cell as a running total in that cell ?
    By jlg371 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 02-01-2009, 08:40 PM
  6. Adding numbers from a single cell
    By hri1428 in forum Excel General
    Replies: 7
    Last Post: 09-18-2008, 06:48 PM
  7. Adding 5 numbers to a single 3 digit
    By wd8ekd in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 07-26-2008, 01:49 PM
  8. Adding numbers in a single cell
    By chefcasey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2005, 02:05 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