Count occurrences of data according to date from a different sheet

[JSpinks06]

I will try to explain this as best I can please bare with me.

Here is the situation I have:
On the first sheet (for the sake of this post we will call Sheet1) I have a list of multiple items in one column which are dates formatted as such: month-day-year

Also on Sheet1 I have another column with a list of text based items that vary but create a recurring list such as:

1. FTP Access
2. HTTP
3. Proxy
4. Detection

What I need is a way to create on Sheet2 a sum of items occurring on a specific date listed by item for instance:
How many times on 7-7-15 did FTP Access occur.

I have a column spanning B2:B100 which is in reference to dates such as 7-7-15.
On the same sheet I have a column spanning G2:G100 listing varying text items such as FTP Access.
Is there any way to do this?

I have a close deadline for this any assistance I can get would be a life saver. I have tried all kinds of solutions from the internet and multiple forums and nothing is really working.

 

[Chrisdontm]

						On this date;

<colgroup><col style="mso-width-source:userset;mso-width-alt:1621;width:34pt" width="46"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:938;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:3185;width:67pt" width="90"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="mso-width-source:userset;mso-width-alt:2872;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:711;width:15pt" width="20"> <col style="width:48pt" span="2" width="64"> </colgroup><tbody>
[TD="width: 46"][/TD]
[TD="class: xl68, width: 64"]Column A[/TD]
[TD="width: 26"][/TD]
[TD="class: xl68, width: 90"]Column C[/TD]
[TD="class: xl68, width: 64"][/TD]
[TD="class: xl68, width: 77"]Column E[/TD]
[TD="class: xl68, width: 30"][/TD]
[TD="class: xl68, width: 81"]Column G[/TD]
[TD="class: xl68, width: 20"][/TD]
[TD="class: xl68, width: 64"]Column I[/TD]
[TD="width: 64"][/TD]

[TD="class: xl68"]Row #[/TD]

[TD="class: xl68"]Total[/TD]

[TD="class: xl68"]↓
[/TD]

[TD="class: xl80"]How Many;[/TD]

[TD="class: xl78"] ↓
[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl78"] ↓
[/TD]

[TD="class: xl68"]3[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

[TD="class: xl76"] HTTP
[/TD]

[TD="class: xl82, align: right"] 7/7/2015
[/TD]

[TD="class: xl83"] 4 [/TD]

[TD="class: xl68"]4[/TD]
[TD="class: xl69, align: right"]7/8/2015[/TD]

[TD="class: xl81"]Proxy
[/TD]

[TD="class: xl86"] ↓
[/TD]

[TD="class: xl68"]5[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP
[/TD]

[TD="class: xl68"]6[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl73"]
[/TD]

[TD="class: xl68"]7[/TD]
[TD="class: xl69, align: right"]7/12/2015[/TD]

[TD="class: xl81"]Proxy[/TD]

[TD="class: xl77, colspan: 6"]=COUNTIFS($D$4:$D$10,$F$4,$B$4:$B$10,$H$4)[/TD]

[TD="class: xl68"]8[/TD]
[TD="class: xl69, align: right"]7/8/2015[/TD]

[TD="class: xl81"]FTP Access[/TD]

[TD="class: xl74"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl75"] [/TD]

[TD="class: xl68"]9[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

</tbody>

 

[JSpinks06]

						On this date;

<tbody>
[TD="class: xl68"]Column A[/TD]
[TD="width: 26"][/TD]
[TD="class: xl68, width: 90"]Column C[/TD]
[TD="class: xl68, width: 64"][/TD]
[TD="class: xl68, width: 77"]Column E[/TD]
[TD="class: xl68, width: 30"][/TD]
[TD="class: xl68, width: 81"]Column G[/TD]
[TD="class: xl68, width: 20"][/TD]
[TD="class: xl68, width: 64"]Column I[/TD]
[TD="width: 64"][/TD]

[TD="class: xl68"]Row #[/TD]

[TD="class: xl68"]Total[/TD]

[TD="class: xl68"]↓[/TD]

[TD="class: xl80"]How Many;[/TD]

[TD="class: xl78"] ↓[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl78"] ↓[/TD]

[TD="class: xl68"]3[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

[TD="class: xl76"] HTTP
[/TD]

[TD="class: xl82, align: right"] 7/7/2015
[/TD]

[TD="class: xl83"] 4 [/TD]

[TD="class: xl68"]4[/TD]
[TD="class: xl69, align: right"]7/8/2015[/TD]

[TD="class: xl81"]Proxy[/TD]

[TD="class: xl86"] ↓[/TD]

[TD="class: xl68"]5[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

[TD="class: xl68"]6[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

[TD="class: xl71"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl73"][/TD]

[TD="class: xl68"]7[/TD]
[TD="class: xl69, align: right"]7/12/2015[/TD]

[TD="class: xl81"]Proxy[/TD]

[TD="class: xl77, colspan: 6"]=COUNTIFS($D$4:$D$10,$F$4,$B$4:$B$10,$H$4)[/TD]

[TD="class: xl68"]8[/TD]
[TD="class: xl69, align: right"]7/8/2015[/TD]

[TD="class: xl81"]FTP Access[/TD]

[TD="class: xl74"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]
[TD="class: xl75"][/TD]

[TD="class: xl68"]9[/TD]
[TD="class: xl69, align: right"]7/7/2015[/TD]

[TD="class: xl81"]HTTP[/TD]

</tbody>

The following is more or less what the list looks like on Sheet1:

if that doesnt work here is the dropbox link:
https://www.dropbox.com/s/avdbao3qcgahbrb/excel example.JPG?dl=0


I need Sheet2 to be able to selectively put data from paired data sets into a single cell.
For instance Cell B2 in Sheet2 needs to show data from 6-28-15 with a count of all occurrences of HTTP on those specific dates.