How to find count of values based on multiple criterias?

[doge_3]

I have 4 colums: Team, Status, Project Name, and Start date

I want to write a formula based on a drop down list of things from Team, Status, and Project Name, and I am having lots of trouble.

How can I get a count of how many things there are where start date is say, before 8/15/14, where the Team, Status, and Project Name are equal to the values in the drop down list? Let's say the drop down list is in A1 (team), A2 (Status), A3(Project name), and A4(start date)

Please help me out!

I have to do this without using filter or pivot... they want it like this :/

 

[VBA Geek]

I made up a simple example, this should get you started


<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">A4</th><td style="text-align:left">=COUNTIFS(<font color="Blue">F2:F11,A1,G2:G11,B1,H2:H11,C1,I2:I11,"<"&D1</font>)</td></tr></tbody></table></td></tr></table><br />

Excel 2013
	A	B	C	D	E	F	G	H	I
1	Barcelona	1	A	05/05/2014		TEAM	STATUS	PROJECT NAME	START DATE
2						Chelsea	1	C	24/10/2014
3						Real Madrid	4	C	25/06/2014
4	1					Barcelona	1	A	27/04/2014
5						AC Milan	3	C	07/09/2014
6						AS Roma	5	B	03/04/2014
7						Arsenal	5	B	22/04/2014
8						Real Madrid	2	C	13/11/2014
9						Barcelona	5	C	08/07/2014
10						AC Milan	2	B	17/09/2014
11						Chelsea	5	C	21/05/2014
Sheet4

 

[doge_3]

Thank you so very much.

You are amazing!