How to calculate a alphabet [Solved/Closed]

danny - Jul 23, 2009 at 12:20 AM - Latest reply:  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
See more 

12 replies

Best answer
Excelguru 261 Posts Saturday April 11, 2009Registration date June 21, 2011 Last seen - Jul 23, 2009 at 02:09 AM
10
Thank you
Hello Danny

Try
=countif(Range,"=P") where range is your data range where P & A are marked

Thank you, Excelguru 10

Something to say? Add comment

CCM has helped 1867 users this month

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 261 Posts Saturday April 11, 2009Registration date June 21, 2011 Last seen - Jul 23, 2009 at 04:05 AM
2
Thank you
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
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - 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)??
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Aug 5, 2010 at 11:51 AM
Dont have a MAC to tell you that. See if this works for you
=SUMPRODUCT(($A2:$AD2="N") *1)
THANKS I GOT IT
Thanks so much...it was really helpful
Excelguru 261 Posts Saturday April 11, 2009Registration date June 21, 2011 Last seen - Jul 24, 2009 at 12:22 AM
0
Thank you
Check historical questions in this forum for answer to this question