Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |