View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
terryc[_2_] terryc[_2_] is offline
external usenet poster
 
Posts: 20
Default countif when 2 values in a cell

I'm using 1 column. It will contain A, B, C, D, etc. My countif works great
when I count A's, B's etc. But there are times there is an AB or A B in the
cell. It neither counts the A or the B. Any suggestions. I see some solutions
of countif were pivot tables. If that's my solution, I'll need beginner help.
Thanks to all.