Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DMAX function for Office 2007
I hope I can explain this in words...
I have some excel worksheets, the first worksheet has a table with multiple house listings and their sales price, along with other info. The table also includes the type of dwelling, (ex, condo, ranch style, victorian). In another worksheet, I was trying to use the DMAX function to get me the max sale price for each type of dwelling. When I used the help it showed... Dmax (database, field, criteria) I was putting =DMAX(selecting the worksheet with the data, then selecting the Header for Sales Price, then selecting the worksheet that I am putting this formula in and typing C10 , which says one of the types of dwellings) I tried for hours, different ways of doing this and I could not get anywhere. Can anyone understand what I am asking, and please explain what I am doing wrong? THANK YOU! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200710/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DMAX function for Office 2007
Assume the table is A4:H50, you also need to create a criteria range, assume
the header for the sale prices are called Prices and the header for the house styles is called Styles Criteria range is J1:J2 with Styles in J1 and condo in J2 =DMAX(Sheet1!A4:H50,"Prices",J1:J2) replace names ranges etc with your own of course an easier way might be to use a single array formula like =MAX(IF(Sheet1!A5:A50="condo",Sheet1!B5:B50)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "jswiryd via OfficeKB.com" <u36919@uwe wrote in message news:7a84860741997@uwe... I hope I can explain this in words... I have some excel worksheets, the first worksheet has a table with multiple house listings and their sales price, along with other info. The table also includes the type of dwelling, (ex, condo, ranch style, victorian). In another worksheet, I was trying to use the DMAX function to get me the max sale price for each type of dwelling. When I used the help it showed... Dmax (database, field, criteria) I was putting =DMAX(selecting the worksheet with the data, then selecting the Header for Sales Price, then selecting the worksheet that I am putting this formula in and typing C10 , which says one of the types of dwellings) I tried for hours, different ways of doing this and I could not get anywhere. Can anyone understand what I am asking, and please explain what I am doing wrong? THANK YOU! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200710/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
can not find the pivot function in office 2007 | Excel Discussion (Misc queries) | |||
Can not find Pivot function in office 2007 | Excel Worksheet Functions | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
MSNStockquote function is not working in Office 2007 beta | Excel Worksheet Functions |