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