Can I count multiple parameters?
=Sum(countif(A:A,{"11A","9A"}))
--
Regards,
Tom Ogilvy
"Jerry" wrote in message
...
I am trying to get Excel to count 2 similiar parameters within a given
range.
I need to countif for both the terms (11A and 9A). I am currently doing 2
seperate cells for this operation.
Thanks for any assistance.
Jerry
|