+ Reply to Thread
Results 1 to 4 of 4

sumif sfunction multiple criteria

  1. #1
    Registered User
    Join Date
    05-29-2017
    Location
    new york
    MS-Off Ver
    offiice professional
    Posts
    2

    sumif sfunction multiple criteria

    Hello all, I was working on the following problem online. The goal was to use sumifs to find the total the amount of active visits that exceeded 10 visits. I got the correct answer using the formula below

    =SUMIFS(C41:C45,A41:A45,"active",B41:B45,">=10") This formula works

    Answer = 325


    =SUMIFS(C41:C45,A41:A45,E40,(B41:B45,>=F40)) This formula does not work


    I tried to do this problem with cells instead of text for "active" and "10", but I'm not getting an the answer. E40 and F40 were the cells the word active and the number 10 were located at.

    Status Visits Amt active 10
    Active 4 100
    hold 15 250
    active 10 125
    active 18 200
    hold 9 180

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: sumif sfunction multiple criteria

    Hello & Welcome to the Forum,

    Try...

    =SUMIFS(C141:C145,A141:A145,E40,B141:B145,">="&F40)
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    05-29-2017
    Location
    new york
    MS-Off Ver
    offiice professional
    Posts
    2

    Re: sumif sfunction multiple criteria

    works thanks

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: sumif sfunction multiple criteria

    You're welcome and thanks for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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] Multiple Criteria SUMIF Using Column as Negative Criteria
    By freybe06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 04:46 PM
  2. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  3. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  4. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 AM
  5. SUMIF with multiple criteria, one criteria a specific string
    By Weasel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2008, 05:32 PM
  6. [SOLVED] SUMIF with multiple criteria
    By stacyjhaskins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] SUMIF with multiple criteria
    By stacyjhaskins in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] SUMIF with multiple criteria for multiple columns to sum a single
    By SavageMind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 11:05 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