| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGEIF equivalent in excel 2000
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| @DSUM (123) equivalent in excel | New Users to Excel | |||
| I need the equivalent of a "averageif" formula... | Excel Discussion (Misc queries) | |||
| Excel needs an AVERAGEIF function similar to SUMIF. Please! | Excel Discussion (Misc queries) | |||
| Series equivalent in Excel 2000 | Charts and Charting in Excel | |||
| EXCEL -- want to do have ''averageif'' - like sumif function - H. | Excel Worksheet Functions | |||
Threaded Mode
