+ Reply to Thread
Results 1 to 8 of 8

COUNTIFS and SUMPRODUCT help

Hybrid View

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    New Hampshire, United States
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Formula Help

    =sumifs(a2:a5, b2:b5, "=3.25", c2:c5, "=360")

  2. #2
    Registered User
    Join Date
    07-18-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Standard 2010
    Posts
    3

    Re: Formula Help

    I got the formula to work, but now I am needing to add another condition and it is not working. Can you tell me what is wrong with this formula?
    =SUMIFS($A$2:$A$47,$B$2:$B$47,4%,$C$2:$C$47,120,$C$2:$C$47,180)
    Thanks for your help!

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula Help

    You're testing the range C2:C47 for 2 different conditions at the same time.

    C2:C47 = 120
    C2:C47 = 180

    The cells can not = 120 and 180 at the same time so the result will always be 0.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    07-18-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Standard 2010
    Posts
    3

    Re: COUNTIFS and SUMPRODUCT help

    Ok, I understand that. So what do you do if you want to sum up numbers from column A that have a specific rate in column B and EITHER a 120 OR 180 in column C?

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: COUNTIFS and SUMPRODUCT help

    Like this...

    =SUM(SUMIFS($A$2:$A$47,$B$2:$B$47,4%,$C$2:$C$47,{120,180}))

+ 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. Replies: 6
    Last Post: 10-08-2009, 03:45 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