Try Sumproduct:

=sumproduct((A1:A2700=2005)*(b1:b2700=1))

Whe

Column A is your Year column and
Column B is your Semi column.

HTH.


cdsta wrote:
Using Excel 2000 - I have 2700+ rows of data to analyze, spreadsheet has 15
columns of data. I want to count the rows which meet particular criteria for
the "year" column (number formatted cells) and and the "Semi" column, also a
number formatted cells. I just want a count of the # of rows in which say,
year = 2005, semi = 1. I have not been able to get a "IF" formula to work
nor an array formula. Any ideas? The countif function works when I only
seek one set of data, like "2005", but selecting cell ranges and nesting
functions is not working. Any Ideas?