ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DCOUNT Help! (https://www.excelbanter.com/excel-discussion-misc-queries/209367-dcount-help.html)

fearthespear

DCOUNT Help!
 
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

microsoft.public.excel.worksheet.functio[_2_]

DCOUNT Help!
 
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



All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com