AVERAGEIF equivalent in excel 2000

  • Thread starter Thread starter flumpuk
  • Start date Start date
F

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
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(A1:A100="set location",B1:B100))
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

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






- Show quoted text -
Click to expand...

Thanks

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