Results 1 to 6 of 6

How to Sum based on criteria

Threaded View

  1. #1
    Forum Contributor BlastRanger's Avatar
    Join Date
    09-02-2010
    Location
    Indonesia
    MS-Off Ver
    2003, 2007, 2010
    Posts
    238

    How to Sum based on criteria

    Hi,
    Look This example :
    -------A---------------B
    blastranger------100
    rangerblade-----200
    blastranger------200
    Monkey----------300
    Rabbit------------400
    rangerblade-----500
    Monkey----------100
    Rabbit-------------200

    I want to sum the Value of blastranger and Rabbit which will return result :
    900

    I use SUMIFS(B1:B8,A1:A8,"blastranger",A1:A8,"Rabbit")
    the result is 0

    I wonder why it is 0, how to sum using SUMIFS, or do I make some mistake here?
    Last edited by BlastRanger; 09-30-2010 at 04:34 AM.
    Please give a Reputation as a gift for a thanks.
    By clicking the second icon at the top right corner of a user post or reply

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