DAVERAGE, MIN, and MAX from another worksheet

[Shelina]

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!

 

[Martin Fishlock]

Hi Shelina:

Have a look at the help pages to use the database functions for the the
functions or look at http://www.techonthenet.com/excel/formulas/daverage.php.


You basically need a seperate database to set the criteria.

If you need formulas try using sumproduct.

 

[Ashish Mathur]

Hi,

The DMIN, DMAX functions will work well only for the answer in one cell.
Copying and pasting down will cause problems. While there is workaround to
that problem but that would entail using Data Tables.

If it easiest to work with thr MIN(if and Max(if array formulas. Someone
has already helped you with those in another thread you started.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com