I assume you would use a formula with your checkboxes linked to cells

=A1*B1+A2*B2+A3*B3

so column A would be linked to your checkboxes and column b would contain
the corresponding numbers to add.

If you wanted to do the show column you could do

=sumif(A:A,True,B:B)

--
Regards,
Tom Ogilvy

"TheDeep" wrote in
message ...

Hi

I've got 14 checkboxes. Each one when ticked picks up a different set
of numbers. They don't however work cumulatively ie. click 3 boxes and
get the cumulative result. Is there a piece of coding I need to add to
eack of the checkbox macros???

Would appreciate some insight ;)


--
TheDeep
------------------------------------------------------------------------
TheDeep's Profile:
http://www.excelforum.com/member.php...o&userid=26675
View this thread: http://www.excelforum.com/showthread...hreadid=399448