=sumproduct((d4:d60="jones")*(j4:j60="disc"))
or
=sumproduct(--(d4:d60="jones"),--(j4:j60="disc"))
--
David Biddulph

"sorry1" wrote in message
...
i am trying to get a count fo cells for

=countif(and(d4:d60,"jones",j4:j60,"disc"))
--
clueless