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)
"Steve_K" wrote in
message ...
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
--
Steve_K
------------------------------------------------------------------------
Steve_K's Profile:
http://www.excelforum.com/member.php...o&userid=29136
View this thread: http://www.excelforum.com/showthread...hreadid=488565