One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(A1:A100="set location",B1:B100))

In article .com,
flumpuk wrote:

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?

Thanks

Brian