| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2000 - array formulas
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
Threaded Mode
