Turn on thread page Beta
    • 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.
 
 
 

1,123

students online now

800,000+

Exam discussions

Find your exam discussion here

Poll
Should predicted grades be removed from the uni application process
Useful resources

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

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