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.
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.
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.
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks