How to get a count on specific data

Hi All

I have two tables - Table A is detail for books with a start and finish date and Table B is a goals table where it includes the year, a column for the goal of books to read and I want a column that shows the number of books read based on the Year column in Table A. In Table A, there is a column called Year, where I used formula to pull out the year from the Finish date.

All I want is a count of 1 for each line where a book was finished in 2020. Likewise when the year 2021 is added, I want that to only show a count of books read where finish date is 2021 and so on,

Is there a way to do this when two tables are involved?

Emma

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.