=Countif(A2:A100,"Yes")

=Countif(A2:A100,B1) where B1 contains criteria to be counted e.g "Yes"

HTh

"control engineer" wrote:

Can anyone please help me calculate the total number of a particular item in
a column e.g number of yeses or noses. and display this value so that i can
then create a graphical representation of the data

thanks
--
kevin