COUNTIF Function with AND Function

RJT

Trying to count instances where item has PV-E Validation and the Status is Complete. My current formula is below and is not working.

=COUNTIF({PV Type}, "PV-E Redemption") AND({PV Express Status}, "Cancelled"))

Leroy Noriega

Try:

=COUNTIFS({PV Type:PV Type}, "PV-E Redemption", {PV Express Status:PV Express Status}, "Cancelled")

RJT

That worked. Thank you