Ctrl+Shift+Enter
=AVERAGE(IF(A2:A7="London",B2:B7))

flumpuk wrote:
Hi

I have a shed load of data on spreadsheest to analyse

They are laid out as follows

Coumn A is a list of locations . There are 84 locations but 1500
entries.
Coulmn B is a a list of numbers relating to the location next to it in
column A.

I need to average all the numbers in column b where colum A meets a
certain criteria.

Sample data

London 12
Glasgow 13
London 11
London14
Newcastle 13
Glasgow 12

And so on


How do I do this in excel 2003. I know in Excel 2007 we have AVERAGEIF
but not in excel 2003