AVERAGEIF equivalent in excel 2000

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

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

  • Re: 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)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I thought I put the formula in the spreadsheet with the .cell, ... Your totals are not saved with it. ... difference at all to the output in excel. ... ' Declare necessary API routines: ...
    (microsoft.public.access.forms)
  • Re: Looking for Easiest Way to Create Report
    ... By recording Excel macros and editing them you may be able to get all this down to one button push in each application. ... run your query then that makes life very much easier than it would have been if you'd had to match values line by line. ... So, if you do go for the query and TransferSpreadsheet route, that leaves you with the problem of levering in the four header rows. ... My guess is that the simplest solution will be in Excel, if you're prepared to do the job in two stages: one which generates the spreadsheet from Access, and another which requires you to move to Excel to add the headers. ...
    (microsoft.public.access.gettingstarted)
  • Re: why>?
    ... properly conceived spreadsheet models ... I can do excel macros; i've written hundreds and thousands of pages ... Anyway, I don't produce reports, regularly scheduled or otherwise. ... Databases aren't unnecessarily 'complex'. ...
    (microsoft.public.excel)
  • Re: Parsing Excel spreadsheets
    ... I presume you talking about using Excel 2003 and saving as ... "XML Spreadsheet ". ... I extracted primarily cell contents, though I did some very limited ... I looked, briefly, at xlrd. ...
    (comp.lang.python)