+ Reply to Thread
Results 1 to 4 of 4

combine countif formulas into 1 formula

Hybrid View

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    combine countif formulas into 1 formula

    I want to combine multiple countif formulas into formula. I need to add up all the cells in a range that meet one of a number of criteria.

    Ex. Criteria: cells value = ball, tree, car, or step

    if the range has 4 trees, 3 balls, 5 cars, and 3 steps, the countif would equal 15.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,129

    Re: combine countif formulas into 1 formula

    you probably need to add them together

    =COUNTIF(A1:A100,"balls")+COUNTIF(A1:A100,"car")+ etc
    OR
    =SUM(COUNTIF(A1:A7,"balls"),COUNTIF(A1:A7,"car"))

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    Jupiter
    MS-Off Ver
    Excel 2013
    Posts
    78

    Re: combine countif formulas into 1 formula

    yeah i was thinking i may have to.

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

    Re: combine countif formulas into 1 formula

    One way...

    Use cells to hold the criteria:

    C2 = ball
    C3 = tree
    C4 = car
    C5 = step

    Then, this formula:

    =SUMPRODUCT(COUNTIF(A2:A100,C2:C5))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

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