Jump to content

Recommended Posts

Posted

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.

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.



ร—
ร—
  • Create New...