Thread: Counting within a list

I have a list on Sheet2 with entries listing student names with their graduation years (Column B) and whether or not they were awarded one of two scholarship (marked with an asterisk in Column C and/or D). On Sheet1 I've set up a table that totals up how many people are from each year and how many got their scholarship in the respective years. Currently I'm running using the following formula (this one checks to see if they are a 2010 graduate and have scholarship C...

=SUMPRODUCT((Sheet2!B:B=2010)*(Sheet2!C:C="*"))

While this works, checking through all of Column B and all of Column C makes any alteration of the sheet take about 30 seconds because it's rechecking both columns in full. I know I can set it to only check through a certain number of cells, but as the list is updated every year with additional students I'd rather have it scale automatically. Is there a way have the formula only check cells that are in the list? Or the last non-blank cell in the list (or sheet, as the list starts at A1)? I'm on a Mac so VBA scripts are out of the question unfortunately.