Question

Felipe wants to find the number of scooters sold in the Mini category (cell D6) along with the total amount of revenue generated from those scooters. In cell E6, enter a formula using the DCOUNTA function and structured references to the Orders table. Use the [#Headers] and [#Data] in the Orders table (range A11:G74) as the formula database. Use the Category field header (cell C11) as the field to count. Use the values Felipe set up in the range D5:D6 as the criteria.

Answer 1

To find the number of scooters sold in the Mini category and the total revenue, use the DCOUNTA function and structured references.

Step-by-step explanation:

To find the number of scooters sold in the Mini category (cell D6) along with the total revenue generated, you can use the DCOUNTA function and structured references in cell E6.

The formula would be: =DCOUNTA(Orders[#Data], "Category", D5:D6)

This formula counts the number of non-blank cells in the 'Category' column of the 'Orders' table (range A11:G74) that match the criteria set in cells D5 and D6.

Answer 2

To achieve this task, Felipe can use the DCOUNTA function along with structured references to the Orders table. Here's the formula for cell E6:

=DCOUNTA(Orders[#Data],"Scooter",D5:D6)

This formula assumes that the Orders table is located in the range A11:G74, and it counts the number of entries in the "Scooter" column (Mini category) that meet the criteria specified in the range D5:D6.

Make sure to adjust the formula if the actual range or column names are different in your spreadsheet. To achieve this task, Felipe can use the DCOUNTA function along with structured references to the Orders table.