Hi. I have a spreadsheet that has tons of data generated daily Column A is a location and Column B is a number. I want to average all the numbers in Column B only when the location in the adjacant column A is a set location. IN Excel 2007 I am using AVERAGEIF command. However. I need to do the> same function in excel 2000 . How do I do this?

Insert a column before column A.
Type a location in column A and type this formula in column C:

=SUMIF(B1:B65536, A1, C1:C65536)/COUNTIF(B1:B65536, A1) and press enter.

Hope it will work for you.