COUNTIFS with multiple criteria
I need help with creating a formula where there are several criteria based off two different things. My columns are "Received from LO" needs to be yes and "Document Type" is several criteria "Lease"; "Easement"; "Option"; and "Easement Option". I can't seem to figure it out. I have the first one done, but can't figure out how to get the multiple criteria in one formula.
=COUNTIFS([Document Type]:[Document Type], ="Lease", [Received from Counterparty]:[Received from Counterparty], ="Yes")
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!