Dan,

can you show the data and your exact formula. Just type it into the message
with appropriate spacing for readability.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dantheman" wrote
in message ...

Thanks, I think we're on the right track. But my sum cell shows "0"
which can't be true. Any other ideas? Thanks.:)


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile:
http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=548722