ExcelBanter - hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION (https://www.excelbanter.com/excel-worksheet-functions/6253-how-use-operator-countif-function.html)

Marty

hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION

I am trying to count 2 different values that could be in a cell. Is it
possible to do that with the COUNTIF function? If so, what is the syntax?

Thanks.

Frank Kabel

Hi
try
=SUM(COUNTIF(A1:A100,{"value1","value2"}))

--
Regards
Frank Kabel
Frankfurt, Germany

"Marty" schrieb im Newsbeitrag
...
I am trying to count 2 different values that could be in a cell. Is
it
possible to do that with the COUNTIF function? If so, what is the
syntax?

Thanks.

All times are GMT +1. The time now is 01:59 AM.