total cells with text and number EX: GS-5
 

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.

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.

total cells with text and number EX: GS-5
 

It seems like you want to count, not total, cells with specific contents. If
that is true, try something like this:

For values in A1:A100
B1: =COUNTIF(A1:A100,"GS-4")

That formula counts the number of cells in A1:A100 that contain "GS-4".

Does that help?
(apologies if this is a dbl-post....network is acting up)

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.

total cells with text and number EX: GS-5
 

THANK YOU VERY MUCH



"Miguel Zapico" wrote:

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.

total cells with text and number EX: GS-5
 

THANK YOU VERY MUCH

"Ron Coderre" wrote:

It seems like you want to count, not total, cells with specific contents. If
that is true, try something like this:

For values in A1:A100
B1: =COUNTIF(A1:A100,"GS-4")

That formula counts the number of cells in A1:A100 that contain "GS-4".

Does that help?
(apologies if this is a dbl-post....network is acting up)

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.