Previous Topic Next Topic

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

Answer 1 / 3
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
danny
Jul 23, 2009 at 02:18 AM
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
Answer 2 / 3
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
danny
Jul 23, 2009 at 04:34 AM
thank you excel guru,i got it
danny
Jul 24, 2009 at 12:06 AM
hI excelguru,one more quastin,
how to get the valuse in waords.
examle total amount of billing in words
erika
Aug 5, 2010 at 01:03 AM
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
erika
Aug 5, 2010 at 11:28 AM
hey it works actually on microsoft excel but y cant this formula cannot work in MacOS X (NeoOffice applications)??
Answer 3 / 3
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses