COUNTIFS with multiple criteria

Amna Collins

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.

Kelly Moore

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)))

Kelly Moore

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)))

Amna Collins

@KDM, thank you so much! It works! I truly appreciate it! 😃