Countif multiple range

I want to calculate Ticket Priority with a specific date; how to use the counif formula like

How many tickets which Have Priority Normal and received in the month of June Only

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓


    Like this:

    =COUNTIF(Date:Date, AND(@cell >= DATE(2023, 6, 10), @cell <= DATE(2023, 6, 24)))

    If you have additional criteria (such as in the first example, you would switch to COUNTIFS:

    =COUNTIFS(Date:Date, AND(@cell >= DATE(2023, 6, 10), @cell <= DATE(2023, 6, 24)), Type:Type, "Normal")

    If you need to change the range then just alter the numbers in the DATEs (Year, Month, Day).

    Hope this helps! 🙂


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!