formula help

[eherring]

In cell H 19 I need to obtain the SUM of cells H16:H18. Cell H18 is a form control checkbox and contains the formula =IF(N18=TRUE, "$390.00", "$0.00").

If I enter the formula {=SUM(IF(N$18=TRUE,H16:H18, "0"))} in cell H19 it only calculates cells H16 and H17.

Thanks

 

[dazfoz]

You could use

=if(N18=True,H16+H17+$390,0)

Daz

 

[Aladin Akyurek]

In cell H 19 I need to obtain the SUM of cells H16:H18. Cell H18 is a form control checkbox and contains the formula =IF(N18=TRUE, "$390.00", "$0.00").

If I enter the formula {=SUM(IF(N$18=TRUE,H16:H18, "0"))} in cell H19 it only calculates cells H16 and H17.

Thanks

Does modifying

=IF(N18=TRUE, "$390.00", "$0.00")

to

=IF(N18=TRUE, 390, 0)

help?

 

[eherring]

that doesn't work for the false, but it gave me an idea

{=SUM(IF(N$18=TRUE,H16+H17+390, H16+H17))} works for true or false

thanks!!!

 

[Aladin Akyurek]

that doesn't work for the false, but it gave me an idea

{=SUM(IF(N$18=TRUE,H16+H17+390, H16+H17))} works for true or false

thanks!!!

=IF(N18=TRUE, 390, 0)

was meant for H18.

Although a bit unclear (to me) where you are heading, wouldn't the following regular formula

=SUM(H16:H17,IF(N$18, 390, 0))

cover the same as the one you post above?

 

[eherring]

=IF(N18=TRUE, 390, 0)

was meant for H18.

Although a bit unclear (to me) where you are heading, wouldn't the following regular formula

=SUM(H16:H17,IF(N$18, 390, 0))

cover the same as the one you post above?

=SUM(H16:H17,IF(N$18, 390, 0)) worked also. Thanks for the input! All of the formulas in my form are calculating correctly!!