Excel formula

[Val]

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??

[sanskar_d]

val,

Hi!!,

I feel using autofilters may help.


Please post your query a little more descriptive or mail me the sheet with some manual results so i can work out.

Mail me on [email protected]

Regards,

Sam