I have a table of children, which school they attend and which year group they belong to (Sheet1). I have a second table (Sheet2) with the list of schools and in which geographic area they're located.
I would like a summary table (Sheet3) which summarises the numbers of children by year group...