Asked By
bruce.max
50 points
N/A
Posted on - 08/14/2011
I've made an Excel Sheet for the Staff Attendance of my company.
The Present of staff is Marked in Excel Sheet as "P", while Leave is Marked as "L".
Just like below:
I want to know an Excel formula which automatically calculates the number of "P" = Present for a Staff Member in a month as well as the "L" = Leaves of a Staff member in a month.
Please reply soon.
Bruce
Excel Formula: To Calculate Letters in Column.
It's a pretty simple formula. Â What you will need is the COUNTIF function.
Below is a link from office.microsoft.com that explains the COUNTIF function. It also shows some examples.
Microsoft Office
Now let's discuss your spreadsheet. Assuming that your Ps and Ls are in the cells from A1 to A200, we can write the 2 formulas below:
For counting those who are Present (counting the number of cells with "P"):
-
COUNTIF(A1:A200,"P");
-
The result would be the number of cells containing "P" in the range A1 to A200.
For counting those that are on Leave (counting the number of cells with "L"):
-
COUNTIF(A1:A200,"L");
-
The result would be the number of cells containing "L" in the range A1 to A200.
Good luck on your spreadsheet! Hope this helps!
