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