Creating Formula using check boxes
 

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..

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Anthony Slater" schrieb im
Newsbeitrag ...
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..

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?

Anthony Slater wrote:
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..

Thanks guys

You put me on the right track...

"Aladin Akyurek" wrote:

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?

Anthony Slater wrote:
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..