My data looks like this:

A Last name
B First Name
C Year
D Academy

I've been trying to count people where year = 2007 and Academy = Arts. (And
also different years and different academies.) I want my counts to be on
Sheet 2.

When I used =sumproduct an Update Values: Sort window pops up. Can someone
please point me in the right direction? Thank you.