Prev: Thanks
Next: Range with 2 validations
From: Shelina on 6 Nov 2009 17:52
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
From: Martin Fishlock on 8 Nov 2009 03:09
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.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Shelina" wrote:

> 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
From: Ashish Mathur on 8 Nov 2009 03:11
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

"Shelina" <Shelina(a)discussions.microsoft.com> wrote in message
news:3AFCC7DB-DC8A-4B17-82D3-795C382C308E(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Thanks
Next: Range with 2 validations