Count occurrences of data according to date from a different sheet

JSpinks06

New Member
Joined
Jul 8, 2015
Messages
2
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.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Column AColumn CColumn EColumn GColumn I
Row #On this date;Total

How Many;

37/7/2015HTTPHTTP
7/7/2015
4
47/8/2015Proxy

57/7/2015HTTP
67/7/2015HTTP
77/12/2015Proxy=COUNTIFS($D$4:$D$10,$F$4,$B$4:$B$10,$H$4)
87/8/2015FTP Access
97/7/2015HTTP

<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>
</tbody>
 
Last edited:
Upvote 0
Column AColumn CColumn EColumn GColumn I
Row #On this date;Total
How Many;
37/7/2015HTTPHTTP
7/7/2015
4
47/8/2015Proxy
57/7/2015HTTP
67/7/2015HTTP
77/12/2015Proxy=COUNTIFS($D$4:$D$10,$F$4,$B$4:$B$10,$H$4)
87/8/2015FTP Access
97/7/2015HTTP

<tbody>
</tbody>

The following is more or less what the list looks like on Sheet1:
excel%20example.JPG

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.
 
Upvote 0

Forum statistics

Threads
1,215,239
Messages
6,123,818
Members
449,127
Latest member
Cyko

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top