ExcelBanter - multiple criteria in one field 4a,4b etc of countif?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - multiple criteria in one field 4a,4b etc of countif? (https://www.excelbanter.com/excel-discussion-misc-queries/51392-multiple-criteria-one-field-4a-4b-etc-countif.html)

Anne-Marie

multiple criteria in one field 4a,4b etc of countif?

Now trying to do COUNTIF(A5:X5,"5a,5b") etc but it keeps telling me I have an
error
More help would be appreciated.

Peo Sjoblom

multiple criteria in one field 4a,4b etc of countif?

=SUMPRODUCT(--(A1:A10={"5a","5b"}))

--

Regards,

Peo Sjoblom

"Anne-Marie" wrote in message
...
Now trying to do COUNTIF(A5:X5,"5a,5b") etc but it keeps telling me I have
an
error
More help would be appreciated.

All times are GMT +1. The time now is 11:27 PM.