Results 1 to 3 of 3

Sum based on whether multiple cells don't contain multiple values

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Sum based on whether multiple cells don't contain multiple values

    So I can't wrap my head around this one. I'm trying to get the total of all cells on Sheet 1 Column B that do not equal the values on sheet 2 (D2:D5) whether positive or negative that are labeled as Non-Union in Sheet 1 Column A to populate in cell E5 on Sheet2.

    I know this sounds pretty confusing but I've attached a sample spreadsheet that I hope makes it easier to understand. Any help on this is much appreciated.
    Attached Files Attached Files
    Last edited by Jluc; 02-28-2011 at 07:05 PM.

Thread Information

Users Browsing this Thread

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

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