Question: Please HELP!!! The third calculation Alex wants to make is to determine the total payments for the policy type of the client he is looking

Please HELP!!!

The third calculation Alex wants to make is to determine the total payments for the policy type of the client he is looking up, which now appears in cell J6. Calculate the total payments for a policy type as follows:

In cell K7, begin to enter a formula using the DSUM function.

Use structured references to the [#Headers] and [#Data] in the Clients table to specify the formula database.

Use a structured reference to the Payment field header to specify the field to summarize.

Use the values in the range J5:J6 as the criteria.

I can't seem to get right this answer. I used this formula =DSUM(Clients[#All],Clients[[#Headers],[Payment]],J5:J6) but it says that:

In the Clients worksheet, the formula in cell K7 should use structured references to the [#Headers] and [#Data] in the Clients table as the database argument.

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 Accounting Questions!

How can I solve this? Help please! 5. The third calculation Alex wants to make is to determine the total payments for the policy type of the client he is looking up, which now appears in cell J6....

ASAP HELP PLEASE!!!! 13. Alex has created an area in the range J3:K8 for looking up data in the Clients table. First, he wants to find the name of the client by looking up the client ID. He has...

1 5 . Alex also needs to find the policy type for the Client ID entered in cell K 3 . Look up the policy type as follows: a . In cell J 6 , below the "Policy Type" text, begin to enter a formula...

Story plot: tall, square, symmetric. For each technique, give the relevant matrix equations to obtain the solution x, and point out the properties of the matrices involved. Highlight one potential...

[Note: If your formula gives only a scalar metric (e.g. the number of stamps) rather than the actual solution (e.g. which stamps), please also explain how to obtain the actual optimal solution.] [4...

Jot java program to find if a particular element is present in a multi-dimensional array. Here is the related facts that might help to solve the problem - *************** Consider the function zarg...

The third calculation Alex wants to make is to determine the total payments for the policy type of the client he is looking up , which now appears in cell J 6 . Calculate the total payments for a...

A function f is defined by f(x) = 1 + 2x + x2 + 2x3 + x4 + ... that is, its coefficients are c2n = 1 and c2n+1 = 2 for all n ( 0. Find the interval of convergence of the series and find an explicit...

If merchandise inventory is being valued at cost and the price level is decreasing, which of the three methods of costingFIFO, LIFO, or average costwill yield (a) The highest inventory cost, (b) The...

How much are the Wells required to reduce their attributes by on form 9 8 2 ?

An augmented matrix for the following system of equations. 4x-9y+2z=-8 6x-2y+5z=6 y-4z=-5 The entries in the matrix are [ ] ?

5. Identify three characteristics of the dialectical approach.

2. How did business and political interests influence what early intercultural communication researchers studied and learned?

2. Intercultural Encounter. Describe and analyze a recent intercultural encounter. This may mean talking with someone of a different age, ethnicity, race, religion, and so on.