Creating Formula using check boxes

[Guest]

Is it possible to create a formula using various check boxes?

For example, if a check box relating to a particular month is checked, then
that is added to the formula. The formula will then be slowly built according
to what has been checked.

This will be using the SUMPRODUCT formula..

Any ideas/advice appreciated..

 

[Frank Kabel]

Hi
if your checkboxes are for example linked to row 2 you could use something
like
=SUMPRODUCT(--(A2:X2),A3:X3)

to sum row 3 depending on the checked columns

 

[Aladin Akyurek]

What is wrong with a faster SumIf formula...

=SUMIF($C$2:$C$4,TRUE,$D$2:$D$4)

where C2:C4 are cell links for check boxes?

 

[Guest]

Thanks guys

You put me on the right track...

What is wrong with a faster SumIf formula...

=SUMIF($C$2:$C$4,TRUE,$D$2:$D$4)

where C2:C4 are cell links for check boxes?