Re: AVERAGEIF equivalent in excel 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

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

In article <1192489139.089434.232070@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
flumpuk <glover.brian@xxxxxxxxx> 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
.

Relevant Pages

  • AVERAGEIF equivalent in excel 2000
    ... I have a spreadsheet that has tons of data generated daily Column A is ... IN Excel 2007 I am using AVERAGEIF command. ...
    (microsoft.public.excel.misc)
  • Security Startup Dialog
    ... I'm changing from excel to using an html page to open tons of db at ... After reading tons of posting about this subject, ...
    (comp.databases.ms-access)
  • Re: File attachment folder
    ... I know that - but he accepts this as the equivelent of MS. ... When he does the file "save as" thing, it shows tons of Excel ... accept that as advice directly from Microsoft and satisfy his curiosity. ...
    (microsoft.public.outlook)
  • Re: "not enough resources available "
    ... spreadsheets, ranging in complexity from very simple tables (without ... tons of charts. ... Day 1 after we moved to Excel 2007, ... "Don Guillett" wrote: ...
    (microsoft.public.excel.misc)