Displaying Data By Category By Year

[ApugalypseNow]

DATA: list of films released by year, with box office totals and genre

GOAL: Function to sort data by year, then displaying how many films in each genre were released each year.
e.g. horror comedies, romantic films released in 1981, 82, etc

Is there a function, or series of functions, by which I can do this without having to sort through manually? Thank you in advance for your help.

[zbor]

Try Pivot table

[ApugalypseNow]

Well, that tries to sum the years, instead of recognizing the year as a qualifier/condition.

[zbor]

Put the years in first column and group data by year. That should do the trick.
It's hard to give more info without seeing actual workbook.