Countifs or sumifs or something else

Hi there, I am trying to count the days in the Lost time Days column, with the month being 1 and the site being offsite. Can you pleases help me.


Answers

  • Hey @Sandra Rogers,

    In reviewing the images provided, it does appear that your Formula is already configured correctly but it is looking at Month 2 (February) so all you need to do is set this to 1. I've created the example below and a detailed breakdown:

    • Formula (highlighted in yellow): =COUNTIFS(Site:Site, "a", Month:Month, 1, [Lost Time Days]:[Lost Time Days], >0)
    • In our first Range/Criteria, we are looking for "a" in the Site Column
    • In our second Range/Criteria, we are looking for 1 in the Month Column
    • In our last Range/Criteria, we are looking for a number greater than 0 within the Lost Time Days Column

    I recommend reviewing our Help Article: COUNTIFS Function for details and instructions on this topic.

    I hope this helps!

    Jaykel

  • What i am looking for is a total number of days not that there is a number in a column. I t should say 2 days but it shows 1 in the formula that I have now.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You need a SUMIFS instead.


    =SUMIFS({Lost Time Column}, {Month Column}, @cell = 1)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!