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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to calculate and display the number of values in a column (https://www.excelbanter.com/excel-discussion-misc-queries/138336-how-calculate-display-number-values-column.html)

control engineer

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

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

Toppers

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

=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

Mike

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

=COUNTIF(A1:A29,"yeses")+COUNTIF(A1:A29,"noses")

"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

All times are GMT +1. The time now is 07:23 AM.