Measuring mortality using a value of 0 or 1

[Elyxia]

Hi

I am currently trying to work out the mortality, but for this problem I currently have the value of 0 (for dead) or 1 (for alive) instead of a population size or amount of dead individuals.

The way it is set up is that I have families(column 1) set up in different areas(column 2), I then have the individual counts of individuals(column 3) and at last the dead or alive value (column 4). Now what I want to look it is the percentage of mortality between all the families, and for some reason my head is currently not working and I can not figure out a way how to set this up. Hoping you guys could help me!

Edit:
Sorry if the English is hard to understand. But some families (column 1) are also placed in same areas(column 2) and essentially what I want to figure out is the mortality rate of each area.
Thanks!

[TMS]

Without seeing the data, we can only guess. But, maybe, use COUNTIFS to get a count for each family/area, and SUMIFS to count the dead for each family/area. Or, perhaps, AVERAGEIFS.

Given you have Excel 365, there might be something more interesting with FILTER, UNIQUE and so on.

[Elyxia]

I don't want to share my data, but this is essentially how it looks like. So in this table the value of 1 in the Dead column means they are dead, 0 means alive. Now I do have many more rows but again this is basically how it looks.

So from this one I am looking for the percentage mortality of this family, which should be 60% from this mock-up table.

Family	Area	Initial Count	Dead
F20	A1	6	1
F20	A2	5	0
F20	A3	5	1
F20	A4	4	1
F20	A5	5	0

[TMS]

Put that in a spreadsheet with columns and rows and you'll get a formula back.