countif function

Originally Posted by pat39s

Hello,

I need to know how to write a countif function that will count if in the list box the user selects 1 of three selections. In this case it is Yes, No, Total.
On sheet two, It would test to see if it is yes, no, or total and put in one cell on sheet one.

Thanks for your help

Pat

not very much clear that how you want to count and where your data is.
however if data is in the range of A1:A50
to count "yes"
=COUNTIF($A$1:$A$50,"yes")
to count "no"
=COUNTIF($A$1:$A$50,"no")
to count "total"
=COUNTIF($A$1:$A$50,"total")

if this is not what you want, explain clearly.