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