Turn on thread page Beta
 You are Here: Home

# Technophobe here, Help. Spreadsheets. watch

1. 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!!
2. 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!!
3. =COUNTIF(D414,2)+COUNTIF(D414,3)

Extend for any number of variables.

Reply
Submit reply
Turn on thread page Beta
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.

This forum is supported by:
Updated: November 11, 2008
Today on TSR

### Edexcel C4 Maths Unofficial Markscheme

Find out how you've done here

### 1,123

students online now

Exam discussions

Poll
Useful resources

## Articles:

Debate and current affairs forum guidelines

## Quick link:

Unanswered news and current affairs threads

## Groups associated with this forum:

View associated groups

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.