Creating Formula using check boxes

A

Anthony Slater

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

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
 
Top