Count cells for certian data

[andespoint]

Hi guy's i have a spreadsheet with a column that can contain an F or COL. I
want to count how many of each I have and display the info in another cell.
Would anyone know how to do this using a formula/function?

Thanks for any help.

[Ragdyer]

Say the column containing the data was Column A, then try these in a cell in
any other column:

=Countif(A:A,"F")
=Countif(A:A,"COL")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"andespoint" <andespoint@nospam_yahoo.com> wrote in message
news:%[email protected]...
> Hi guy's i have a spreadsheet with a column that can contain an F or COL.
> I want to count how many of each I have and display the info in another
> cell. Would anyone know how to do this using a formula/function?
>
> Thanks for any help.
>

[andespoint]

Thanks for the great information and Help.


"Ragdyer" <[email protected]> wrote in message
news:%[email protected]...
> Say the column containing the data was Column A, then try these in a cell
> in any other column:
>
> =Countif(A:A,"F")
> =Countif(A:A,"COL")
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "andespoint" <andespoint@nospam_yahoo.com> wrote in message
> news:%[email protected]...
>> Hi guy's i have a spreadsheet with a column that can contain an F or COL.
>> I want to count how many of each I have and display the info in another
>> cell. Would anyone know how to do this using a formula/function?
>>
>> Thanks for any help.
>>
>

[Ron Rosenfeld]

On Mon, 26 Jun 2006 15:04:31 -0400, "andespoint" <andespoint@nospam_yahoo.com>
wrote:

>Hi guy's i have a spreadsheet with a column that can contain an F or COL. I
>want to count how many of each I have and display the info in another cell.
>Would anyone know how to do this using a formula/function?
>
>Thanks for any help.
>

Look at HELP for the COUNTIF worksheet function.
--ron