Tracking Attendance Percentages

K

kingj

New Member
Joined
Oct 11, 2010
Messages
7
I have created an excel spreadsheet to track attendance of an exercise class I am teaching. I would like to know each person's current percent attendance. (so if we have had 5 classes and they have attended 4 of those classes then it should show 80%). I would like it to keep a running tab, so as I add in the person's attendace it will continue that count, up to the 26 classes that are being offered. I thought if I did a sumif/countif I could get it to work, but it doesn't. Here is what I tried: =sumif($e$4:$ad:4,">0")/countif($e$4:$ad$4,">1"). Do you have a suggestion that would work? Thanks!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
What do you put in the cells E4:AD4 to signify that the person has attended a class or not?
 
Upvote 0
I have been leaving those who don't attend as blank, though I could change that if it makes a difference in the formula
 
Upvote 0
Well, it depends on whether the whole range E4 to AD4 is to be tested for 1 vs blank, or whether instead you only want to test part of that range ( i.e. only those cells filled with 1's and 0's ).
 
Upvote 0
Percentage of E4:AD4 that are 1's:
=SUM(E4:AD4)/COLUMNS(E4:AD4)
formatted as a percent.
 
Upvote 0
That works in giving me the percentage, but I would like to show if I have had three classes and the student has attended three classes 100%, then when I add in the 4th class and he hasn't attended for the % to change to reflect that.
 
Upvote 0
Please explain the process behind "when I add in the 4th class" ( i.e. how is the percentage formula to determine how many classes there are ). Is it the case that you insert a new column for a new class? Where is the percentage formula located exactly?
 
Upvote 0
You must log in or register to reply here.

Similar threads

Juddman79
  • Question
Multiple Group Attendance Percentage
Replies
8
Views
374
BrerRabbit
B
O
  • Solved
Limit filter list to unique values
2
Replies
11
Views
281
smozgur
smozgur
M
  • Question
Dynamic calculations based on Dates
Replies
1
Views
157
Kaper
Kaper
P
  • Question
calculating attendance percentage based on the number of days in a week worked
2
Replies
10
Views
468
Plasmech
P
M
  • Solved
Rolling Percentage issue
Replies
8
Views
308
Fluff
Fluff

Forum statistics

Threads
1,214,920
Messages
6,122,267
Members
449,075
Latest member
staticfluids

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top