CountIFs Summary Formula For Multiple Variables

Sara Gibbs

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!

JamesB

@Sara Gibbs

Using your formula, I am able to make it work. Can you share a screen capture of the fields you are referencing? is the Year of Incident a date field?

Sara Gibbs

No it is a drop-down list to choose a year. We only want the year in the cell and not a full date.

Sara Gibbs

Sara Gibbs

Found my issue. Appreciate your help!