Formula to look up column A which contains Dates

[KNKN9]

Hi,

I have a file that contains:

column A Column B Column c ......
01/07/2017 x x
01/07/2017 x x


I need a formula that will look up the month in column A and give me the data corresponding for this month from column B. Example. If I am after July, I need a formula that will look up all data for July. At the moment I have the formula " =COUNT('All Req'!A195:A196)" . But every month I have to manual change the row number.

Thanks
Naomie.

 

[Joe4]

I think you want to use COUNTIF, where you can apply criteria to your count.
See here for how to count records for a specific month: https://exceljet.net/formula/summary-count-by-month-with-countifs

 

[KNKN9]

Thanks