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?