View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default total cells with text and number EX: GS-5

You can use countif, for example:
=COUNTIF(A1:A20,"GS-4")
The second parameter is the criteria, you can use a cell reference instead,
to make the formula more flexible.

"dap1" wrote:

Want to total cells in which the text is 2 letters followed by a number
between 1 and 15. Example want to know how many GS-4 are in a given range of
cells.