Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup more than one value across a table
i have a spreadsheet with 52 rows of data relating to properties, i.e. 52
properties. in column B i have the information to which office location it belongs (10 different offices). in column H i have the price of the property. i now would like to summarise a total for each office. i tried to use the following formula =OFFSET(A1,MATCH("Nottingham",B2:B52,0),7) but it only returns the first value matching the criteria and doesn't add up the other 4 belonging to this office. how can i extend/amend the formula to either show all results in a list or add them up already? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Value in Table | Excel Worksheet Functions | |||
Table lookup | Excel Worksheet Functions | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
lookup a value in a table | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |