Count nubmer of time a date in specific month appears

[studio95]

Hello all,

I have a worksheet which contains dates that people have been out on visits and wish to report how many times there was a visit occurrence within a particular month undertaken by a particular individual for a specific reason. Both the individual and reason are also logged on the worksheet.

i.e

columns AK:BV is the range in which dates are logged
column H is where the name of the individual undertaking the visit is logged
column J is where the reason is logged

The sheet I am generating the report on lists the reasons in column A, row 6 is where I have 12 columns to represent each month of the financial year going from B8:M8 April to March accordingly.

B2 is where I will select the individual from a drop down list.

I would like cell B8 to look at the worksheet containing the data a count the number of times a visit occurred in April-17 in the range AK:BV, for the person selected in B2 for the reason listed in A8

Does that make sense ?

 

[mart37]

=SUMPRODUCT((DATASHEET!$B$2:$B$10=$A2)*(DATASHEET!$C$2:$L$10>=B$1)*(DATASHEET!$C$2:$L$10<=EOMONTH(B$1,0)))

Cellreferences need to be changed.