Attendance

[Manny74]

So I need to keep track of staff member's attendance, since we have a goal of 80% to meet for calendar year 2018.
I have several workbooks, one for each staff member, since I have other goals I have to track.

As a group, I want toadd up all their monthly attendance, for example:

Attendance forJanuary, PRESENT, PRESENT, ABSENT, So January would have 2 employees were present (see examples of a few workbooks below)

I thought I could use=COUNTIF (SMITH:RIVERA!H1,”PRESENT”) But I get a Value1 error…. What am I doingwrong?

I thought I could create a formula to count January's present for multiple workbooks....

SMITH E F G H I J


TARGET CY18 JAN FEB MARCH Q1


[TABLE="width: 472"]
<tbody>[TR]
[TD="width: 126"]

Medicine On Call Meeting Attendance ​

[/TD]
[TD="width: 139"] Attendance
[/TD]
[TD="width: 47"]

80%​

[/TD]
[TD="width: 64"]

3​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 51"]

3
​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Meetings
[/TD]
[TD="width: 64"]

11​

[/TD]
[TD="width: 68"]

1/30/18​

[/TD]
[TD="width: 68"]

2/7/18​

[/TD]
[TD="width: 68"]

3/5/18​

[/TD]
[TD="width: 51"]

3​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Percentage
[/TD]
[TD="width: 64"]

27.27%​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 51"]

100%​

[/TD]
[/TR]
</tbody>[/TABLE]

​

JONES E F G H I J


TARGET CY18 JAN FEB MARCH Q1


[TABLE="width: 485"]
<tbody>[TR]
[TD="width: 126"]

Medicine On Call Meeting Attendance​

[/TD]
[TD="width: 139"] Attendance
[/TD]
[TD="width: 55"]

80%​

[/TD]
[TD="width: 64"]

2​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 64"]

ABSENT​

[/TD]
[TD="width: 64"]

2​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Meetings
[/TD]
[TD="width: 64"]

11​

[/TD]
[TD="width: 68"]

1/30/18​

[/TD]
[TD="width: 68"]

2/7/18​

[/TD]
[TD="width: 64"]

3/5/18​

[/TD]
[TD="width: 64"]

3​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Percentage
[/TD]
[TD="width: 64"]

18%​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 64"]

​

[/TD]
[TD="width: 64"]

67%​

[/TD]
[/TR]
</tbody>[/TABLE]


RIVERA E F G H I J TARGET CY18 JAN FEB MARCH Q1


[TABLE="width: 485"]
<tbody>[TR]
[TD="width: 130"]

Medicine On Call Meeting Attendance​

[/TD]
[TD="width: 139"] Attendance
[/TD]
[TD="width: 55"]

80%​

[/TD]
[TD="width: 64"]

1​

[/TD]
[TD="width: 64"]

ABSENT​

[/TD]
[TD="width: 64"]

ABSENT​

[/TD]
[TD="width: 68"]

PRESENT​

[/TD]
[TD="width: 64"]

1​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Meetings
[/TD]
[TD="width: 64"]

11​

[/TD]
[TD="width: 64"]

1/30/18​

[/TD]
[TD="width: 64"]

2/7/18​

[/TD]
[TD="width: 68"]

3/5/18​

[/TD]
[TD="width: 64"]

3​

[/TD]
[/TR]
[TR]
[TD="width: 139"] Percentage
[/TD]
[TD="width: 64"]

9%​

[/TD]
[TD="width: 64"]

​

[/TD]
[TD="width: 64"]

​

[/TD]
[TD="width: 68"]

​

[/TD]
[TD="width: 64"]

33%​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[ranman256]

pivot and just count the presents. no need for a forumula.

 

[Manny74]

Sorry I had the workbooks on a word document, and tried to paste it to my thread, after I posted it, the data shifted, which makes it hard to read....

 

[Manny74]

How would I pivot?