DCOUNT with 1 Criteria ?

[kilown]

Hello,

I am using Excel 2010, and have a few things i am trying to do but its not working,

I have a Advanced Filter that has removed 2 list, with 3 criterias, List ( or DB1 ) is based off 1 item " Pay type ( hourly / Salary )" , then the 2nd List is based off 2 Criteria's Job type , and Less than a number, I am able to do the filter just fine, but i am requried to DCOUNT theses.

here are the ranges for the Default Table: A6:H45 (without headers)

List1 is in J6:Q27
List2 is in J33:Q37

*Both are without headers also*

I am asked to "DCOUNT"

List 1 based (A6:H45,"Type",L30)
List 2 based (A6:H45,"Job Type"+"Salary(has to be <55,000)",L29,M30)

* Now I know i can just count them based off the filter but thanks to my never ending school ( yes this is homework please dont judge me ) I have to do the DCOUNT.*

Dont worry I have to do compound intrest next based off all the data and its not fun either.



Below is a general idea on how things are set up, if you need more info about what the actual sheet looks like or want more info I can give you what ever you need. ( If you want the sheet I will have to email it to you )

First	Last	Full	Location	Job Titile	Type	Salary	"The Man"
a	A		House	Manager	Salary	20	Jimmy Buffett
b	B		House	Banker	Hourly	22	Jimmy Buffett
c	C		Office	Typer	Hourly	20	Jimmy Buffett
d	D		Farm	Grower	Salary	90	Jimmy Buffett
e	E		Farm	Dutchoven	Salary	90	Jimmy Buffett
f	F		Office	Manager	Hourly	20	Jimmy Buffett
g	G		House	Wife	Hourly	1000	Jimmy Buffett

<tbody>
</tbody>

 

[kilown]

Bump

 

[kilown]

Solved


=Dcount (A6:H45, ,F55:F56)

I took the headers and added it to the bottom then just put in what i wanted for the count, and used it.