Formula help

[AwesomeSauce]

Hi,

I have a data range (dates) in one worksheet that tracks the date of the event. I want to summarise, by month/ Year, on a separate worksheet.

However, I quite fancy NOT using explicit ranges so I can change a cell to the correct year (e.g. 2019), and it looks up the month and counts the number of events that occurred.

Any thoughts welcome?

Best regards,

Andrew

[#2]

You may do that by Pivot Table, please see attached

[#3]

Thank you - I must have completely formula blinkered not to think about pivots! :o