Excel formula
 

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

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

Regards,

Sam


--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=378882