Try this€¦

For First criteria
=COUNTIF(SHEET2!A:A,"BLOGGS")

For Second Criteria
=SUMPRODUCT(--(SHEET2!A1:A19="BLOGGS"),--(SHEET2!C1:C190))

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Puzzled" wrote:

I have a 2 sheet work book where the cover sheet needs to show the
statistical breakdown of sheet 2.

In the cover sheet I have already inserted a column which performs a €˜count
if function looking for occurrences of a specific surname in the surname
column A of sheet 2.

1. What formula do I need to use in the next column in my cover sheet to
count if surname €˜Bloggs in Column A of sheet 2 and of these €˜bloggs also
have €˜Yes in Column B of sheet 2?

2. What formula do I need to use in the next column in my cover sheet to
count if surname €˜Bloggs in Column A and of these €˜bloggs also have €˜0
in Column C of sheet 2?