how can i total a phrase on microsoft excel?

faizak

New member
ok, I'm making a drop down list. it says something like (present /absent)
so if there the two options what formula can i use so that it totals everytime how many times you are present and how many times you are absent seperately.
 
Top