View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shelina Shelina is offline
external usenet poster
 
Posts: 8
Default DAVERAGE, MIN, and MAX from another worksheet

On worksheet Q6-7, I need a formula that gives me the DAVERAGE from worksheet
Q3-5 for the table SalesData3 column Sales Price, but only for the Condos
(there are Condo, Ranch, and Victorian) in column Style.

Also on worksheet Q6-7, I need two formulas that give me the MAX and MIN
from worksheet Q3-5 for the table SalesData3 column Sales Price, but only for
the Condos in column Style.

Lastly, I have tried to filter table SalesData3 for all the Condos, but all
I get is the first entry on the table, which happens to be a Condo. I've also
used Ranch and Victorian in the criteria and got the exact same result, the
first entry on the table. There are 23 Condo entries, 46 Ranch, 48 Victorian.
Any idea what could be wrong there?

Thanks!
--
Shelina