HI Fera! I think this would help you understand your need.
1- Go to Excel
2- In the fx look for the function DCOUNT
3- Click on it
4- You will see a box. Click where it says "Help with this formula". Here it
is pretty straight forward how does the function work.

If you still don't understand, I might be able to help you but I need you to
send me an email, so I can forward copy of this explanations

Good luck.




"fearthespear" wrote:

I am not doing this properly please help!
I have a table shownig days on market
days Number Sold Avg Price
1-100 ? ?
101-200 ? ?
201-300 ? ?
301-400 ? ?
How do i use DCOUNT to put in number sold between 1-100 days on the market?
SalesData- Table info is in.
Employee data- WS table is in.
Days on Market-Header in WS