Results 1 to 6 of 6

questions about sumif

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2017
    Location
    taipei
    MS-Off Ver
    2007
    Posts
    3

    questions about sumif

    I have some trouble using sum and sumifs, I have data similar to below,

    items Name Color free cost
    item 1 red, blue, yellow Y 100
    Item 2 blue, yellow,black, white Y 50
    Item 3 red, yellow N 20
    Item 4 green, N 12
    item 5 green, red, blue, Y 22
    item 6 White, red Y 24

    Now I wanted to find "color" contains "blue or yellow or white", AND free = Y, then sum up these items cost,
    but no matter how I use sum of sumif, it will either calculate item 2 and item 6 twice, or it will only calculate if color string contains "Blue&Yellow&white"

    anyone can help?

    thanks
    Last edited by instantreply; 09-07-2017 at 02:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Lookup/COUNTIF/SUMIF Questions
    By chrisbeaudet in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2017, 10:58 PM
  2. Due dates sumif/countif formula questions
    By amauryroseline in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2014, 01:07 PM
  3. [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
  4. SUMIF questions
    By lindaguzman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2014, 09:45 AM
  5. Excel 2010: How do i answer these questions with SUMIF/VLOOKUP?
    By at13 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 11-07-2013, 01:32 PM
  6. [SOLVED] SUMIF questions
    By Johnny Image in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 07:17 PM
  7. questions that aren't really excel questions
    By martindwilson in forum The Water Cooler
    Replies: 1
    Last Post: 03-11-2012, 08:21 PM

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