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

Medicine On Call Meeting Attendance ​	Attendance	80%​	3​	PRESENT​	PRESENT​	PRESENT​	3 ​
Meetings	11​	1/30/18​	2/7/18​	3/5/18​	3​
Percentage	27.27%​	​	​	​	100%​

<tbody> </tbody>

​

JONES E F G H I J


TARGET CY18 JAN FEB MARCH Q1

Medicine On Call Meeting Attendance​	Attendance	80%​	2​	PRESENT​	PRESENT​	ABSENT​	2​
Meetings	11​	1/30/18​	2/7/18​	3/5/18​	3​
Percentage	18%​	​	​	​	67%​

<tbody> </tbody>

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

Medicine On Call Meeting Attendance​	Attendance	80%​	1​	ABSENT​	ABSENT​	PRESENT​	1​
Meetings	11​	1/30/18​	2/7/18​	3/5/18​	3​
Percentage	9%​	​	​	​	33%​

<tbody> </tbody>

 

[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?