Checkbox help
 

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

Checkbox help
 

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

Checkbox help
 

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


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

Checkbox help
 

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)


"Steve_K" wrote in
message ...

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


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