How to calculate a alphabet [Solved/Closed]

Report
-
 Hilda -
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 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello Danny

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us 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
Status
Member
Last seen
June 21, 2011
307
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
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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
Status
Member
Last seen
June 21, 2011
307
Check historical questions in this forum for answer to this question