total amount due

Hi

looking to add a formula in this spreadsheet that will total the amount to be paid by the males in cell M18 not sure how to separate the male from the female

Copy of Ski_Trip_Finances PT.xlsx I know its quite simple but for the life of me I can't get it

Toddp2

Try

=SUMIF(D:D,"Male",H:H)

Might need to change H:H to another column as I wasn't sure which column of numbers you wanted to use.