Thread: HOW DO I ADD NON-NUMERIC VALUES
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default HOW DO I ADD NON-NUMERIC VALUES
Do you mean COUNT?
=COUNTIF(A1:A20,"cat") will count how may times a cell in A1:20 has the
value "cat"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DUKE" wrote in message
...
HOW DO I ADD NON-NUMERIC VALUES?


Reply With QuoteReply With Quote