Hi Bob,

Thank you for your time and assistance. I've tried your formula but get a
count of zero, I know there should definitely be a count of more than zero.

=SUMPRODUCT(--((COUNTIF(INDIRECT("A"&ROW(numbers)&":I"&ROW(numbe rs)),72)0)
*(COUNTIF(INDIRECT("A"&ROW(numbers)&":I"&ROW(numbe rs)),73)0)))

Further help appreciated.

Regards,
Sam

--
Message posted via http://www.officekb.com