Technophobe here, Help. Spreadsheets.

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!!

Reply 1

Anderson8

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!!