For Attendance, In Excel sheet we are putting the name of employees and filling the cells with their present by "P" and "A" for absence. Now we would like to count how much "P" are there in the raw towards employee name, Please advice which formula we have to use here.