TheLaughingMan Posted July 7, 2010 Share Posted July 7, 2010 Ive searched all over the net and having a real hard time with this. Im using the attendance template in Numbers and I modified it and made it bigger, works great except that I want it to total the attendance by DATE as well as name which it already does. So a total at the bottom which is working and now Im trying to add a total along the side at the end of the date rows to show how many show up each day. Im trying to mimic the formula used for name total but I just cant seem to get it working. So there is no confusion, adding a SUM at the end is easy for numbers added up, very simple, what I need is to total up the checkboxes that are checked off I have in the spread sheet though. Link to comment Share on other sites More sharing options...
TheLaughingMan Posted July 7, 2010 Author Share Posted July 7, 2010 Ya well of course I figure it out right after posting this, ah well. I was trying to add them up using the countif function like it does for name attendance... instead it worked using countifs with an s..... no idea why but it works to total up the checkboxes per day. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now