=SUMPRODUCT(--(issued_by_range=A8),--(Period_all_range=1))

--
HTH

Bob Phillips

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

"david" wrote in message
oups.com...
Can anyone help me with the format for combining COUNTIF and AND in a
single function - I can't seem to get the format right.

What I want to do is COUNTIF range 'Issued_by' = A8 AND range
'Period_all' = 1

Thanks for any help

David