Hello,
I hope somebody can help me with this question and I hope this is interesting to some other people on the forum as well.
I have attached a sample of the data I'm working with: Sheet1 contains the raw data and Sheet2 a summary table.
On Sheet1, each row represents a death record and includes year (column A), region (column B) and cause of death (column C).
On Sheet2, there's an empty summary table I would like to fill up with the data from Sheet1. For each of the regions listed below "county_name" (cell A2) I would like to record the number of death records for each death cause ranging from years 1986 to 1988 only (inclusive).
This means that, for each possible death cause ("druknet", "påkjørt", "ingen info", "skutt", "skutt (lovlig)", "trolig selvdød"), I should have the number of death records per region between 1986 and 1988.
How can I count the number of rows on Sheet1 meeting all this multiple criteria and paste this information on the table in Sheet2?
I would appreciate if I could be set into the right track!
Bookmarks