Attendance spreadsheet

[Guest]

I am trying to track employees coming to a meeting.

I have their names and the scheduled meeting dates. I need to calculate at
the end of each month the percent of meetings they attend. For example, if
there are 2 meetings and they attend both I need the cell to show 100%. I do
not know what or how to mark the cell, and what formula to use to recognize
they attended.

THANKS!!!!

 

[Richard O. Neville]

For each month, enter the total number of meetings into a cell . Let's say
it's cell G2 and there are 4 meetings.

Next, you will need five columns: A for the name of the employee, and
B-C-D-E for the 4 meetings. Column F will be for the percentages and should
be formatted for %. Your first employee entry is Ms. Able; her name goes in
A2. She attended meetings 2 and 3, so enter "1" in C2 and D2 (if you want,
you could put "0" in B2 and E2).

In F2, enter this formula: =(B2+C2+D2+E2)/$G$2 and the answer should be 50%.
The $ signs are to make the reference absolute rather than relative. Enter
the rest of the names in column A; enter their attendance records for the
four meetings; then spread the formula down column F in one of two ways.

If you hold the mouse near the bottom right corner of F2, its shape will
change to a black +. Depress the left mouse button and drag down the column.
Or, click on F2, then shift-click on the last cell needing a formula, and
press Ctrl D.