arrays.xls
This sample file will count how many cells in a column contain numbers within a range; for example, counting the numbers that are less than 10 but greater than 30. The answers need to be entered into a results page on the worksheet. See this month's Q&A to see how this works.

Online: N/A OS: Windows 95/98/Me/NT/2000/XP License: Free Requirements: Microsoft Exce; Download arrays.xls: