View Single Post
  #4   Report Post  
Anthony Slater
 
Posts: n/a
Default

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