Help with CountIf

Hi Everyone,

I am new to formulas and have been struggling with a CountIf (I'm sure this won't be my last questions).

I've watched videos and looked at past logs but I still can't wrap my brain around this simple request.

I am trying to count the number of instances where a specific location has an open request that is notated by a check box. In this case, I want to count where the "open requests" are thus the checkbox would not be selected. I am pulling from a reference sheet into my roll-up sheet.

Here is the formula I have (that is incorrect)

=COUNTIFS({On the Job Injury Log Range 9}, "Baltimore City Correctional Ce", {On the Job Injury Log Range 11}, 0)

Any help in figuring out where I went wrong would be appreciated.


Thanks!

Tabitha

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Yes. THat first one should do the trick.


    As for the <= 60 bit...


    You would use either a COUNTIFS to repeat the range and do your criteria of >= 1 for the first range and<= 60 for the second repetition of the range OR you could use a COUNTIF with the AND. It is your choice. I personally always use COUNTIFS even if I only have a single range.

    =COUNTIFS({On the Job Injury Log Range 10}, >=1, {On the Job Injury Log Range 10}, <=60)

    or

    =COUNTIF({On the Job Injury Log Range 10}, AND(@cell >= 1, @cell <= 60))

    or my personal preference

    =COUNTIFS({On the Job Injury Log Range 10}, AND(@cell >= 1, @cell <= 60))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!