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
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.
below is my excel sheet pls guide me how to calculate those P.
thanx