Sumif multiple criteria

Hi

Does anyone know a sum for the attached, basically I want a sum that will show me

how many single people like icecream
how many married people like icecream
how many couples like icecream

Any help muchly appreciated ?

Maybe a PT:

Thanks Martin, if I were to pull the infor from another sheet on the workbook say for exapmple the sheet was called 'Q1 10-11' how would I include that in the sum ?
I tried =SUMPRODUCT(Q1 10-11'--($D$2:$D$100="Single"),--($C$2:$C$100="Yes"))
but this does not work ?any ideas ?

You don't need to type in.

Just select range you want to use.

So...
Copy/paste formula
Delete $D$3:$D$10
Select range

It works!!thanks guys !