Thread: How to calculate and display the number of values in a column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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
Reply With QuoteReply With Quote