Question: Problem : Use a Database function (DCOUNT, DCOUNTA, etc.) to provide the total revenue from sales for supplies that are not from New Customers (on

Problem: Use a Database function (DCOUNT, DCOUNTA, etc.) to provide the total revenue from sales for supplies that are not from New Customers (on the Sales sheet) with the Category of Floor Wax or Mops & Brooms (on the Sales sheet). You must calculate the total in the criteria range of A1:H3 and also reference K2 in the formula. (In this example, $14.36 should be the total that is returned in cell L2.)

Issue: Using =DCOUNTA('Sales'!$A$4:$H$10, K2, A1:H3) results in $0.00 in cell L2. Replacing K2 in the formula with Revenue from Sales gives the same $0.00 result (which makes sense since Excel recognizes cell K2 as Revenue from Sales as shown in the 3rd screenshot). Perhaps the criteria correct that I have entered in columns D and E is wrong.

Can anyone solve either the correct formula or the correct criteria to have a result of $14.36 show up in cell L2 (on the Database sheet)? I have shortened the data so that it can easily be replicated to test and find the correct answer.

**There is no further information. The needed answer is how to get a result of $14.36 in cell L2 given the Problem statement requirements.

Problem: Use a Database function (DCOUNT, DCOUNTA, etc.) to provide the total revenue from sales for supplies that are not from New Customers (on the Sales sheet) with the Category of Floor Wax or Mops &

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

complete excel spreadsheet using data in case study 4 A 8 c D E F G Calculations Lifetime Value Tuscan Lifestyles: Initial order $50 1 2 3 4 5 6 7 Timeo Year 1 Year 2 Year 3 Year 4 Year 5 2.30%...

Consider and discuss the specific risks and nature of the company you will be auditing. Create comprehensive audit programs for the cash, financial instruments, sale, and receivables accounts and...

QUESTIONS (1) Use the five-step model to compare revenue recognition between the two versions. (15%) (2) Consider the example on p.4 of the case, the last paragraph under the Section "Revenue...

QUESTIONS (1) Use the five-step model to compare revenue recognition between the two versions. (15%) Steps HMM11 HMM12 1. Contract 2. Performance Obligation 3. Contract price 4. Allocate price 5....

(4) Does the accounting change in revenue recognition for HMM12 matter to managers of HBP? (20%) Students should try to access at least two articles (either commentary from professional accountants,...

(3) Why does HBP recognize deferred revenue? (15%) (4) Does the accounting change in revenue recognition for HMM12 matter to managers of HBP? (20%) Revenue Recognition at HBP In early 2014, Paul...

You will write a 2 - 3 page paper, single spaced, one inch margins, 12 pt font, with double space between paragraphs. Your paper should comment on the financial statements for your company as they...

KickButt Coffee Shoppes' By John Kucharczuk Carol Yang just graduated from York University with her BCom and went back to home to Calgary to look for a fulltime job. Living at home saves a lot of...

Bus299: Excel To be answered using appropriate Excel functions and/or formulas. There is no partial credit for incorrect usage. Use appropriate formatting of cells where needed. Save frequently. Keep...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

2. You are planning on purchasing a lot that is 70 x 80 m in size. Local building codes require that your house be constructed 2 3 m away from the existing property lines. You have access to a...

When speaking of power, which of the following is not a component of dependence? Discretion O Importance Non-substitutability Scarcity Question 22 1 pts What conclusion can we make about emotional...

A corporation's board of directors could prefer a stock spit to a stock devidend because a stock split: Multiple Choice Increases total stockholders' equity and allows the corporstion more flexblig....

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...