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

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
 
G

Guest

=Countif(A2:A100,"Yes")

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

HTh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate How the Number of Specific word. 1
How to generate a list from a table 1
Excel How to calculate in excel number of open actions that expired (older then today) 0
Excel Sumproduct 0
How to display 2 pieces of data on one bar of a Pivot Chart? 1
Excel Subtracting multiple columns from another column 3
Looking for Formula 1
HOW TIMES A NAME IS USED IN DROP DOWN LIST 5

Top