+ Reply to Thread
Results 1 to 7 of 7

Sumif unknown criteria

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    86

    Sumif unknown criteria

    Hi all,

    Is there any way how I can sumif/check if sums in Column B according every value in column A are equal to zero. There can be multiple different values in column A.

    Column A:
    y
    x
    z
    z
    z
    y
    x

    Column B:
    -1
    1
    1
    0
    -1
    1
    -1

    Thanks for help!
    Sandra

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,742

    Re: Sumif unknown criteria

    As ...

    =SUMIF($A$2:$A$8,"y",$B$2:$B$8)

  3. #3
    Registered User
    Join Date
    06-07-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Sumif unknown criteria

    That's not exactly what's needed. The thing is that all available criterias in column A is unknown. I need somehow to sumif them all. That's part pf VBA code.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Sumif unknown criteria

    Wouldn't it then just be a plain old sum (to sum ALL the criteria) ?

    =SUM($B$2:$B$8)

  5. #5
    Registered User
    Join Date
    06-07-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Sumif unknown criteria

    Thanks, but for this check in particular I need to make sure that sum is equal to zero according every separate criteria...;/

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Sumif unknown criteria

    Maybe this in C2 and filled down

    =SUMIF($A$2:$A$8,A2,$B$2:$B$8)=0

  7. #7
    Registered User
    Join Date
    06-07-2013
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Sumif unknown criteria

    Yeah, that will perfectly do a trick! Thanks

+ 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] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  2. [SOLVED] Max & Min unknown malfunction with multiple criteria
    By smit.etha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2014, 06:01 PM
  3. Average CountIF or SumIF between unknown ranges?
    By MJSlattery in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 03:40 PM
  4. Replies: 0
    Last Post: 04-18-2012, 06:51 AM
  5. Filter by unknown criteria problem
    By thornton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2011, 12:56 PM
  6. Summing across unknown range in unknown cell!
    By agentred in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-28-2009, 10:10 AM
  7. Display 'UNKNOWN' in a cell if the criteria doesn't match
    By famico78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2008, 09:55 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