Checkbox help

S

Steve_K

This is what i am trying to do. I have one column with check boxes.
Second with numbers. Third with a cumilative column. Total at the
bottom. If the box is checked add it to the total if not, don't add
it.



1| CB | 21 | 21 |
2| CB | 31 | 52 |
3| CB | 12 | 64 |
Total 64

Thanks
 
B

Bob Phillips

If the checkboxes are forms checkboxes, and linked to cells in say column M,
you could use

=SUMIF($M$1:$M$100,1,B$1:B$100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

Steve_K

does this formula go in where my total is? your criteria is 1. when
check the box column M says true or false not
 
B

Bob Phillips

Yes it does. You must be using ActiveX checkboxes then.

Use

=SUMIF($M$1:$M$100,TRUE,B$1:B$100)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top