How to calculate and display the number of values in a column

  • Thread starter control engineer
  • Start date
C

control engineer

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
 
T

Toppers

=Countif(A2:A100,"Yes")

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

HTh
 
Top