COUNTIFS with multiple criteria

Options

Hi!

I am traying to work with the COUNTIFS formula to:

  • Count by Platform column if between 01/01/2021-12/31/2021 in the Actual End column
  • Struggling with the Platform that has one-letter value (X or S) as X keeps getting counted in both the X and Xi platforms
  • Currently trying the following formula =COUNTIFS({Platform}, CONTAINS("X", @cell), {Actual End}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 12, 31)))


Any insight is much appreciated.

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Amna Collins

    Try the HAS function instead of CONTAINS. HAS looks for an exact match and should then differentiate between X and Xi.

     =COUNTIFS({Platform}, HAS(@cell, "X"), {Actual End}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 12, 31)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!