98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating a database relating to sickness, punctuality etc
Creating a database relating to sickness, punctuality etc
Resolved · Medium Priority · Version 2007
Wed 14 Nov 2012, 16:17Delegate Lara said...
Lara has attended:
Excel Introduction course
Creating a database relating to sickness, punctuality etc
How do you create a database for 50 employees that counts in a total box at the end... eg. by entering sick it would count as 1 each time etc. But also being able to achieve this without having to have every single date across the top.
Fri 16 Nov 2012, 10:23Trainer Simon said...
RE: Creating a database relating to sickness, punctuality etc
Hi Lara,
Thank you for your question and welcome to the forum.
In a cell try and use a CountIF function. Please find the attached spreadsheet.
In essence what the formula does is to count the number of cells in a range that contain the word sick. So it sees each cell with sick in it as a number.
I hope this answers your question.
Regards
Simon
Attached files...
Count number of sick days in a range.xlsFri 23 Nov 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut keys to move between sheetsInstead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file: |
