AVERAGEIF equivalent in excel 2000

[flumpuk]

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

 

[JE McGimpsey]

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

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

 

[flumpuk]

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

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






- Show quoted text -

Thanks

Worked a treat. Just read uo about CSE formulas. Still dont understand
why they are what they are , but it works

 

[Guest]

You can use this link:

http://excel-queries.blogspot.com/

Thanks...

 

[Guest]

You can use this link:

http://www.excel-queries.blogspot.com/

Thanks...