View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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