View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
justjill111 justjill111 is offline
external usenet poster
 
Posts: 4
Default count all text values except a certain one

if i have the word 'ditto' scattered among a bunch of names (text), how do i
count every value that's not 'ditto' ? am i trying to combine "COUNTIF"
value with "NOT" criterion...?