View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Killer Killer is offline
external usenet poster
 
Posts: 80
Default Putting line between formula

Hey there

Right now this formula reads both checkmarks and Xs as one but I want it to
show 1-1 instead
=COUNTIF(C4:AJ4,"ˆš*")+COUNTIF(C4:AJ4,"X*")

Also I cant seem to get this formula to add 20 instead its adding 1 only
=COUNTIF(C4:AJ4,"X*")