How to calculate a alphabet

Solved/Closed
danny - Jul 23, 2009 at 12:20 AM
 Hilda - May 30, 2011 at 03:34 AM
Hello,
for my workers I am mainaning attandance sheet and every month I have to send it to my head office.
for their presents iam putting P and for absents A.
my query is ,can we calculate a particular alphabet in one coplete row.
for example: P is mentioned 25 times in 30 days ,can wetake the values of P.
please give me a formula if it is there

3 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 02:09 AM
Hello Danny

Try
=countif(Range,"=P") where range is your data range where P & A are marked
thanx for your instent reply but still I am not able to calculate.
below is my excel sheet pls guide me how to calculate those P.

thanx
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 04:05 AM
Hello Danny

if your data is from column 2 to 30, take 'range' as $A2:$AD2
then put in AE2 as =countif($A2:$AD2 ,"=P") and copy it to below cells in that column
thank you excel guru,i got it
hI excelguru,one more quastin,
how to get the valuse in waords.
examle total amount of billing in words
i had try this format to calculate a particular alphabet but I just cannot get it I dont really understand y what I wanted to count is actually almost the same as danny. for me I just wanted to calculate there is how many new projects(N) for 1 month in 1 column.

pls help
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 5, 2010 at 07:29 AM
Erika what is the error you get
=countif($A2:$AD2 ,"=N")

this count how many times N appears in cell A2 thru AD2
hey it works actually on microsoft excel but y cant this formula cannot work in MacOS X (NeoOffice applications)??
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 24, 2009 at 12:22 AM
Check historical questions in this forum for answer to this question