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