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