Click Personal Profile after login to opt out. In excel there is a group of database functions which I think those of us who write spreadsheets aimed at playing with lists can take advantage of. Being database functions you usually can constrain it to some criteria, eg DSUM the list given that some number in the list does not exceed 5 for example To get a feel for this, I suggest you click on fx in Excel and use the DSUM function following the user friendly instructions. The problem I have is that they don't allow you to obtain results from a table on another worksheet in the same workbook. It will allow you to retrive data from a table on another wooksheet.
Text below is pasted from excel help.
Extracts a single value from a column in a list or database that matches conditions you specify. For more information and examples, click . Database is the range of cells that make up the list or database. A database is a list of related data in which rows of related information are records and columns of data are fields. The first row of the list contains labels for each column.