Looking to create function that counts rows only when 2 conditions are met from different rows
I have two rows in question, one containing a list of states, the other containing a list of "types". I am looking to create a function that only counts rows that satisfy 2 specific criteria. For example, only count rows that contain State = Colorado AND type = payment.
To make things more complicated I am referencing the columns from another sheet.
Any help is greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!