Forum Discussion
Excel formulas
mathetes thank you again. I'll look at it tomorrow And i input the 1 into the spreadsheet from the lunch/milk cards that the students put in a bowl. I do need the totals by day and at the end of the month I need to report my numbers.
I'll get back to you tomorrow!
madgate Here's a "New & Improved" version. I've changed the Input sheet in particular to make it both prettier and, I trust, easier to use. All you need to do on the dates across the top, for instance, is enter the first school day of the month, and all the rest are calculated, skipping weekends automatically.
I've also used the "freeze panes" feature, so that you're not lost off at the right, not being able to see the names of the students. Now the input column for lunch or milk is visible on the screen close to the list of names. It could be made even closer....
Take a look and come back with any of your questions.