Assigning a value to a character (?)

[rahahmed]

Hi,

I have a slight problem in that i need to somehow calculate the total number of certain characters in various fields. So if the spreadsheet contains:

P P P P L L L

This is in one row.

I need excel to count the number of P's and L's, is this possible? I can do it with numbers but i need help with characters.

Thanks.

[Gary''s Student]

Use COUNTIF()


=COUNTIF(A1:Z1,"P") in an un-used cell

--
Gary's Student


"rahahmed" wrote:

>
> Hi,
>
> I have a slight problem in that i need to somehow calculate the total
> number of certain characters in various fields. So if the spreadsheet
> contains:
>
> P P P P L
> L L
>
> This is in one row.
>
> I need excel to count the number of P's and L's, is this possible? I
> can do it with numbers but i need help with characters.
>
> Thanks.
>
>
> --
> rahahmed
> ------------------------------------------------------------------------
> rahahmed's Profile: http://www.excelforum.com/member.php...o&userid=30038
> View this thread: http://www.excelforum.com/showthread...hreadid=497238
>
>

[rahahmed]

Thanks, that works perfectly!