I'm confused why my datafunctions for Average Sales(DAVERAGE) and Total Sales(DSUM) appear to be correct, but I'm getting a 0 for number of sales(DCOUNT). Any suggestions what I'm doing wrong? Unless all of my dfunctions are incorrect?
I'm confused why my datafunctions for Average Sales(DAVERAGE) and Total Sales(DSUM) appear to be correct, but I'm getting a 0 for number of sales(DCOUNT). Any suggestions what I'm doing wrong? Unless all of my dfunctions are incorrect?
Hi,
DCOUNT counts the cells containing numbers, so your field parameter needs to reference any column in the range which contains numerical entries. Try changing it to e.g. 4 or 5.
Regards
You may also use DCOUNTA as alternative.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Why not use the countif/averageif/sumif functions?
=COUNTIF(Sheet1!$C:$C,Sheet2!B$3)
=AVERAGEIF(Sheet1!$C:$C,Sheet2!B$3,Sheet1!$E:$E)
=SUMIF(Sheet1!$C:$C,Sheet2!B$3,Sheet1!$E:$E)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks