I need to add another condition to my formula.

=$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533))


The formula I'm using is works now I need each line to look at Column F and If it equals F15 then do the formula and conditions below.

Each row needs to look at $F53:$F533 to see if it = F15
Each row needs to look at $I53:$I533 to see if it = C15
B15 - (sum( of the true amounts in $H53:$h533

Any help will be appreciate my boss wants this change this afternoon if possible. Please make me look good.