View Single Post
  #1   Report Post  
ferde
 
Posts: n/a
Default Countif in two columns and in different cells

I'm not sure which function I need to add text "p" and "cps" when this
data is in different columns. The total in this ex: would be p+cps = 2.
Any help would be greatly appreciated. I'm new at this.

shift class
p cps
p x
p x
p x
p cps

total p+cps = 2