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 )

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]First[/TD]
[TD]Last[/TD]
[TD]Full[/TD]
[TD]Location[/TD]
[TD]Job Titile[/TD]
[TD]Type[/TD]
[TD]Salary[/TD]
[TD]"The Man"[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]A[/TD]
[TD][/TD]
[TD]House[/TD]
[TD]Manager[/TD]
[TD]Salary[/TD]
[TD]20[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]B[/TD]
[TD][/TD]
[TD]House[/TD]
[TD]Banker[/TD]
[TD]Hourly[/TD]
[TD]22[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]Office[/TD]
[TD]Typer[/TD]
[TD]Hourly[/TD]
[TD]20[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]D[/TD]
[TD][/TD]
[TD]Farm[/TD]
[TD]Grower[/TD]
[TD]Salary[/TD]
[TD]90[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]E[/TD]
[TD][/TD]
[TD]Farm[/TD]
[TD]Dutchoven[/TD]
[TD]Salary[/TD]
[TD]90[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]F[/TD]
[TD][/TD]
[TD]Office[/TD]
[TD]Manager[/TD]
[TD]Hourly[/TD]
[TD]20[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]G[/TD]
[TD][/TD]
[TD]House[/TD]
[TD]Wife[/TD]
[TD]Hourly[/TD]
[TD]1000[/TD]
[TD]Jimmy Buffett[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.