Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DAVERAGE | Excel Worksheet Functions | |||
DAVERAGE | Excel Discussion (Misc queries) | |||
daverage | Excel Worksheet Functions | |||
Daverage | Excel Discussion (Misc queries) | |||
How do I use DAverage in Excel? | Excel Worksheet Functions |