Make formula work only IF a cell has a check?

[drivinatwork]

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

[NBVC]

So you only want to subtract F25 from F24 if there is a check in a cell?

What cell has the check, what if there is no check, what is the result to be returned?

Please clarify.

[drivinatwork]

I have one large amount in F4, then have smaller amounts in F5-F23. I need these amounts subtracted from F4, but not until there is a check in the G cell next to it, to show a total in F25.

ex. if F4 = 100 and F5 = 75 I want F25 to = 25 but only when G5 has a check

Thanks,
JasonO

[NBVC]

=IF(G5="P",F4-F5,0)

replace 0 with what you want if the condition is not met.

[drivinatwork]

Thank you, I'm using it in this way and getting a circular reference message

in H24 I have =SUM(H5:H23) and

in H10 I have =IF(G10="P",H10-F10,200) - I would have this formula in H10,H12,H15,H17

then would want the sum of those cells before and after the ="P"

and thanks again for helping me out

[NBVC]

Go to Tools|Options, and in Calculation tab, check the Iteration checkbox. Click Ok.