simple count or sum function??

  • Thread starter Thread starter Looker
  • Start date Start date
L

Looker

does any one know how to simply, count the amount of times there is a
condition where two seperate colums have two different anwsers, i.e

from C10 to C20 "Yes" and in D10 to D20 "Selected", and all others can
be ignored, to count the amount tof times they match up in the same
row?????

please help im not very good @ excel
 
use the countif function.

for example to count "Selected"

=COUNTIF(E9:E17,"Selected")
 
Back
Top