How to calculate a alphabet [Solved/Closed]

- 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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
- 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 1686 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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
- 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
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- 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)??
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- 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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
- Jul 24, 2009 at 12:22 AM
0
Thank you
Check historical questions in this forum for answer to this question