Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

creating database relating sickn

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

ResolvedVersion 2007

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.

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.xls

Fri 23 Nov 2012: Automatically marked as resolved.

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.