[Solved] Count multiple criteria [closed]

Question

Using sum over countifs would give you what you are looking for. Like for example, assuming you have 200 rows, you may use:

=sum(countifs("A1:A200",106, "B1:B200","EV MEDICAL SERVICES 2019", "C1:C200",{"890701","890602O"}))

Notice the use of curly braces to add a list of comma separated criteria for filtering the last column.

Accepted Answer

Using sum over countifs would give you what you are looking for. Like for example, assuming you have 200 rows, you may use:

=sum(countifs("A1:A200",106, "B1:B200","EV MEDICAL SERVICES 2019", "C1:C200",{"890701","890602O"}))

Notice the use of curly braces to add a list of comma separated criteria for filtering the last column.