F
flumpuk
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
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