Query Help

[agentzero]

Criteria for the query include: Transaction ID, Loan ID, First Name, Last Name, State, Loan Date, Loan Purpose, Loan Amount, Loan Term, Interest Rate, Loan Type, Loan Age(months), Loan Use, New Interest Rate, and Loan Maturity Date.

Query Question: What percent of all loans are of amount at least $30,000 with loan term between 5 and 35, both inclusive?

My criteria was under Loan Amount- <=30000, and Loan Term >=5 and <=35.

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #0057d6}span.s2 {color: #006107}</style>=DCOUNTA(Customer_Loans!A8:K33,H10,Queries!A10:O12)

I got this question wrong.

 

[BrianJN1]

Is this a school/homework questions?

I have the understanding that we may be discouraged to intervene to provide a full solution.
That said, you might be able phrase a question about a specific aspect upon to be advised.