CountIFs Summary Formula For Multiple Variables

I need help creating a summary formula to count 2023 vehicle incidents under 1000 to be counted. Below is my attempt which didn't work

=COUNTIFS([Year of Incident]:[Year of Incident], 2023, [Type of Incident]:[Type of Incident], "Vehicle", [Actual Expense]:[Actual Expense], <1000)

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!