# Counting number of days sick per condition

1. ## Counting number of days sick per condition

Hello.

I’ve got a long spreadsheet with many rows (>5000). Each row relates to a time someone has been off work sick. In two columns (D and G) I have “reasons” for sickness and “Days lost” due to sickens respectively.

I have set up a look-up type formal to search for the reasons for sickness (=COUNTIF(\$D\$4:\$D\$5955,I4), which obviously simply counts the number of times “stress”, for example, appears in my list.
Is it then possible to create a formula to count the number of days lost due to a certain condition without having to calculate this manually? So, the spreadsheet would look up all “stress” in column D and adds up its related value in column G for each “stress”?

Hope that makes sense?

Many thanks

B

2. ## Re: Counting number of days sick per condition

Perhaps a Pivot Table?

3. ## Re: Counting number of days sick per condition

Make use of sumif function like the below:-
Formula:
`Please Login or Register  to view this content.`

4. ## Re: Counting number of days sick per condition

Originally Posted by :) Sixthsense :)
Make use of sumif function like the below:-
Formula:
`Please Login or Register  to view this content.`
that works.

thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1