View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
grizzly6969 grizzly6969 is offline
external usenet poster
 
Posts: 79
Default countif -- mulipl choices

I have on sheet 1 john -- sick
bill --- sick
john --- sick
ted ----- sick
john --- broken leg
is it possible to show on sheet 2 john - sick = 2
john - broken leg = 1
bill - sick = 1
etc. etc.
--
grizz