Having trouble finding a formula to do the following for me.
I have a spreadsheet that has column headings connected to sales. I need to
count the number off "active" properties that each sales person has. I have
columns headings for date, property address, sales persons initials, status
of the property (eg sold, active, off market) etc. Having trouble creating a
formula that will count the results of matching criteria in one column (Sales
Person) to particular criteria in another column (Status). Can anyone help??