If function help needed

[Berandon]

Is it Possible to have an If function run the whole column of "D" that If there is a "1" in the box, it adds a different column but the same row to a box. eg ... If D9-D2000 equals "1" then add M(same Row) to M4 and O(same row) to O4 and P(same Row) to O5.

I guess i could do a different If function for each cell, but I was hoping to consolidate it into 1 cell.

 

[Comfy]

There is a function called SUMIF.

So M4 would be:

=SUMIF(D9:D2000,1,M9:M2000)

 

[Berandon]

Thank you very much! This saved me a lot of time.