Countif formula Month

Options
jgneely72151
jgneely72151 ✭✭✭✭✭
edited 07/05/23 in Formulas and Functions

I have a Month column with multi-select properties for 3 months, September, October, and November. I preparing a metrics sheet and for some reason my countif formula is not calculating appropriately.

When I run the filter on my sheet, here are the values returned for each month:

September =30

October = 40

November = 26

When I write the formula on my metrics sheet, it's returning the following

=COUNTIF({Month}, "September") - I get 12

=COUNTIF({Month}, "October") - I get 21

=COUNTIF({Month}, "November") - I get 9

Am I doing something wrong here?

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @jgneely72151,

    Your formula is only finding the cells which have only that single month in. For a multi-select column you would need a formula like this to see the ones which have multiple values including the one you're after:

    =COUNTIF({Month}, CONTAINS("September",@cell))

    Hope this helps, but if you've any issues then just post! 😊

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Options

    Greetings @jgneely72151,

    I agree with Nick on the solution but wanted to provide a complete formula.

    =COUNTIF(Month:Month, CONTAINS("September",@cell))

    I hope this helps and adds to Nick's answer.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • jgneely72151
    jgneely72151 ✭✭✭✭✭
    Options

    Thanks to you both! I kept saying there has to be a "contain" function and was about to check and got side-tracked. Thanks again for coming to my rescue because I got to get this dashboard up and running ASAP. This is most helpful!☺️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!