# Pivot Table count records for a day

#### tbone56

##### New Member
I have a table which has one row for every school student who is absent for a day. It shows the date, what school year they are in and their gender. I have also on each row, the "number of students" for that school year and gender. In the pivot table I need to show the absent %. I can easily average "the number of students" but how do I get the count of Students (row count) for each day.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hello, I placed the student name field in the values section of the pivot and then did a count of name.

How do I delete / edit my own posts?

Thanks MikeL, I need to rewrite this and explain it better

Replies
2
Views
361
Replies
0
Views
182
Replies
18
Views
328
Replies
1
Views
226
Replies
9
Views
221

1,203,240
Messages
6,054,316
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back