Make formula work only IF a cell has a check?

I was wanting to know can I make some formulas work only if another cell has a check mark(wingdings 2 - capital P) in it?

Basically cells F5:23 add up and then subtract from F4, with the total of F5:23 in F24 then the difference of F4 and F24 in F25, I only want them to subtract if the cell next to them is checked.

Can this be done?

Thanks,
JasonO