Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |