View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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