I have a spreadsheet with the following information:

Active? Type
Y GI
N AD
Y AD
N GI

I need to count how many AD with Y are in the sheet. Would I be using a
COUNTIF, DCOUNTA, or something else entirely? Please help!