How to calculate a alphabet
Solved/Closed
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
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
Related:
- How to calculate a alphabet
- How to alphabetize bookmarks in chrome - Guide
- How to calculate vat in excel - Guide
- How to calculate in spreadsheet - Guide
- How to calculate percentage of marks of 6 subjects - Excel Forum
- How to change number to alphabet in laptop - Guide
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
Jul 23, 2009 at 02:09 AM
Hello Danny
Try
=countif(Range,"=P") where range is your data range where P & A are marked
Try
=countif(Range,"=P") where range is your data range where P & A are marked
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 23, 2009 at 04:05 AM
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
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 5, 2010 at 07:29 AM
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
=countif($A2:$AD2 ,"=N")
this count how many times N appears in cell A2 thru AD2
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 24, 2009 at 12:22 AM
Jul 24, 2009 at 12:22 AM
Check historical questions in this forum for answer to this question
Jul 23, 2009 at 02:18 AM
below is my excel sheet pls guide me how to calculate those P.
thanx