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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=Countif(A2:A100,"Yes")

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

HTh
 
Back
Top