thanks everyone. I looked at the link for SUMPRODUCT and it gave an
example of SUMIF that worked perfectly. Don't know why I did not try
that.
Thanks
Paul
--
Paul Adams
------------------------------------------------------------------------
Paul Adams's Profile:
http://www.excelforum.com/member.php...o&userid=10468
View this thread:
http://www.excelforum.com/showthread...hreadid=277659