Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    1
    ReputationRep:
    Right, id like to know how to use a logical operator in Excel?

    say if id like to filter all the 1s and 3s? in a column.


    I enter =COUNTIF(THE RANGE, "1") For the 1s, and it works!

    I then try and add the operator.... =COUNTIF(THE RANGE, "1" AND "3").. Doesnt work?

    What am i doing wrong? Just says invalid all the time!!
    • Thread Starter
    Offline

    1
    ReputationRep:
    Right, id like to know how to use a logical operator in Excel?

    say if id like to filter all the 1s and 3s? in a column.


    I enter =COUNTIF(THE RANGE, "1 " For the 1s, and it works!

    I then try and add the operator.... =COUNTIF(THE RANGE, "1" AND "3 " Doesnt work?

    What am i doing wrong? Just says invalid all the time!!
    Offline

    4
    ReputationRep:
    =COUNTIF(D414,2)+COUNTIF(D414,3)

    Extend for any number of variables.
 
 
 
Reply
Submit reply
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Updated: November 11, 2008
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Would you like to hibernate through the winter months?
    Useful resources
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.