1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

COUNTIF Function

Discussion in 'Other PC Software' started by UAW/GM, 2002/11/12.

Thread Status:
Not open for further replies.
  1. 2002/11/12
    UAW/GM

    UAW/GM Inactive Thread Starter

    Joined:
    2002/11/03
    Messages:
    8
    Likes Received:
    0
    I am pretty much stuck on ignorant when it comes to spreadsheets. I did however, mudle my way to understanding the basics of the COUNTIF function. Herre is what I am trying to do. Count if a cell matches either of 2 values.

    Column1
    Bananas
    Oranges
    Apples
    Peaches
    Bananas
    Apples

    Now, I want to count if a cell in the above column contains either bananas or apples. I hope I have explained my question clearly.
     
  2. 2002/11/12
    WhitPhil

    WhitPhil Inactive

    Joined:
    2002/01/07
    Messages:
    599
    Likes Received:
    4
    Maybe a better way, but this should work.

    If the values are in cells a1 to a10

    Then the calculating cell would read

    =countif(a1:a10, "bananas ")+countif(a1:a10, "apples ")
     

  3. to hide this advert.

  4. 2002/11/13
    UAW/GM

    UAW/GM Inactive Thread Starter

    Joined:
    2002/11/03
    Messages:
    8
    Likes Received:
    0
    Thanks Whitphil, I wasn't aware one could have more than one function strung together like that. Whether there is a better way or not, your solution will serve my purpose well. Thanks again.
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.