Countifs or sumifs or something else

Sandra Rogers

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.

Annotation 2021-10-20 162811.png

Annotation 2021-10-20 1628111.png

Jaykel Torres

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

Sandra Rogers

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

You need a SUMIFS instead.

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