IF, AND formula needed - Urgent

IDA Pata - Leroy.xlsxHi, im a semi-novice and only know basic formula and brute force coding, been tasked with the following to help out Cyclone relief efforts for NZUND so they can better use the information, and in typical fashion, been given a couple hours to come up with a solution

have column for house level damage (M) and if a 1 is entered in that cell, we have to count the number of people in the household affected which is in column D. and have a looping formula to have a accumulated total for people affected



i can do this (below) but have many sheets with different lengths of info, is there a way to streamline this formula?
=IF(M4=1,D4,0)+IF(M5=1,D5,0)+IF(M6=1,D6,0) etc etc for a couple hundred rows.

I hope im making sense and hopefully someone can help out

Cheers,
Ken

Disaster Managment Samoa

EDIT: have attached 1 village excel sheet, havent yet compiled all lists.

Use Sumif

Formula:

Please Login or Register  to view this content.

Ensure that both the range should have unique row reference

Oops.. your file got messed up with the text

Try this...
=SUMIF(M4:M44,1,D4:D44)