+ Reply to Thread
Results 1 to 2 of 2

Trouble adding multiple cells, then subtracting multiple cells

  1. #1
    Registered User
    Join Date
    08-26-2016
    Location
    usa
    MS-Off Ver
    14.0.4760.1000
    Posts
    25

    Wink Trouble adding multiple cells, then subtracting multiple cells

    I've attached a sample to view the issue. Here's also a screenshot.
    testetestestest.jpg

    I'm trying to add cells G6,I6,K6,M6,O6 and then subtract the sum of H6,J6,L6,N6.
    The formula would be in E6. The total should be 3.

    I've tried the following formula with no luck. I also tried changing the format of the cells from General to Number. I even tried creating two separate columns, one adding the first set, 2nd adding the other cells. But it won't add F6,H6,J6,L6,N6.
    I'm thinking there's a circular reference issue going on but I can't seem to track it down.
    Please Login or Register  to view this content.
    Each cell contains a formula instead of just a number. Example: G6 has =W206 (Helper columns starting a Q206) instead of 1.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-26-2016
    Location
    usa
    MS-Off Ver
    14.0.4760.1000
    Posts
    25

    Re: Trouble adding multiple cells, then subtracting multiple cells

    and... I figured out the issue. I had a circular reference in column N.

+ 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 subtracting multiple cells
    By jdubbcurb in forum Excel General
    Replies: 3
    Last Post: 01-06-2015, 03:56 PM
  2. [SOLVED] Subtracting multiple cells from one cell
    By exceldummy01 in forum Excel General
    Replies: 4
    Last Post: 10-23-2012, 09:57 AM
  3. Subtracting from multiple cells using a remote cell
    By androo829 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2012, 06:33 PM
  4. Subtracting from multiple cells
    By toxictoad in forum Excel General
    Replies: 3
    Last Post: 01-10-2012, 03:26 PM
  5. Excel 2007 : Subtracting Multiple cells on Excel 2007
    By JonRoberts in forum Excel General
    Replies: 3
    Last Post: 06-05-2009, 10:50 PM
  6. [SOLVED] trouble with subtracting cells and adding text...
    By traybuddy in forum Excel General
    Replies: 4
    Last Post: 10-14-2005, 09:05 AM
  7. [SOLVED] RE: trouble with subtracting cells and adding text...
    By Gary''s Student in forum Excel General
    Replies: 1
    Last Post: 10-14-2005, 04:12 AM

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