I suggest you construct a sumproduct table on sheet 2. This can
"analyse" a varying number of rows of data in sheet 1, providing you
can ensure the columns are in the same order every time.

If column A contains names, and cell A1 = names, likewise if column B
contains ages, the formula will be something like:

=sumproduct(($a$2:$a$1000="fred")*($b$2:$b$100039 ))

this finds all the freds that are 40 or older.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=557804