ExcelBanter - View Single Post - excel 2000

cdsta

Thanks. I'll check this out.

"Gary L Brown" wrote:

Check out Chip Pearson's website.
The URL below brings you to a page that shows you how to use multiple
criteria for both SumIf and CountIf.

http://www.cpearson.com/excel/array.htm

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

"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?