I got it figured out, easier then expected

=SUMIF(A2:A32,1,AT2:AT32)


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540155