Thread: formula for totals in column C if they are words rather than numbe
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default formula for totals in column C if they are words rather than numbe
=COUNTIF(C:C,"*suspend*")
=COUNTIF(C:C,"*auth*")
=COUNTIF(C:C,"*pendin*")

--
If this post helps click Yes
---------------
Jacob Skaria


"Dottled" wrote:

I have a spreadsheet and column C has words like suspended, authorised,
pending etc - can I create a formula to total the different states?
Reply With QuoteReply With Quote