for the first one:

=indirect("C"&'Menu Data'!B85")

for the second one:

zero is the code for descending, any positive number should give you
ascending

for the third one you should set up a formula like:

=average(if(apple range = "apple", data range))

where apple range is the range of your description column, and data
range is the column with the numerics.

same principal applies to median - these are both array formulae

for the count, just use countif


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=391709