Count value in a row IF the adjacent row equals a certain value

[JerryA]

Hello all,

I am new to the forum and very much a novice with excel. The worksheet I am working with has three columns. A date, supplied from and received by.

I am trying to work out how to extract how many times has each area supplied to each of the other areas. I have played around with Index and match but that does not seem to work as there maybe multiple hits. To add confusion I would like to be able to tell it to only supply data when the date is before or after certain date.

I plan to have a drop down list with each of the locations. As per below - I would like to be able to select a town from the list and I would like it to tell me that Town has supplied Another once - but does not show The town supplying Another because it was prior to the 10th of the month.

I hope that all makes sense.

Can anyone point me in the right direction?

[KOKOSEK]

Are You able create and attached some sample data, please?

[JerryA]

Basic workbook attached to original post.

[KOKOSEK]

English is not my native language, so I am not sure that I understand you needs.

You want to based of town choosen from drop down (as I understand towns from col C - receiving) shows town from col B - supply.
But could you explain this condition related to date? If 'Poole' been choosen, what town you want to get and why? Hull (23/1) or London (11/1) or Hull (07/1)? Any relation to today's date?

[JerryA]

Ok. Column B is the town that has supplied. Column C is the town that has received. My report must be able to show how many times one town has supplied the others.

For example London has supplied to Poole once and to Hull once.

And Poole has received from Hull twice and from London once.

The date is an issue because the sheet will have data on it for the whole month. However I would be interested in the data between say the 11th of last month and the 10th of this month. Anything after the 10th on this month will be counted in next months figures.

[JeteMc]

Perhaps something like the attached will help.
The start and end dates are placed in G1 and I1 respectively.
The data is populated using: =COUNTIFS(A$2:A$8,">="&G$1,A$2:A$8,"<="&I$1,B$2:B$8,B2,C$2:C$8,C2)