+ Reply to Thread
Results 1 to 4 of 4

Counting number of days sick per condition

  1. #1
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2016
    Posts
    127

    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
    Last edited by burnsie; 03-08-2013 at 05:43 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,885

    Re: Counting number of days sick per condition

    Perhaps a Pivot Table?

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Counting number of days sick per condition

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


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2016
    Posts
    127

    Re: Counting number of days sick per condition

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

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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