| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGEIF equivalent in excel 2000
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=AVERAGE(IF(A1:A100="set location",B1:B100)) In article .com, flumpuk 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGEIF equivalent in excel 2000
On 16 Oct, 00:13, JE McGimpsey wrote:
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =AVERAGE(IF(A1:A100="set location",B1:B100)) In article .com, flumpuk 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- Hide quoted text - - 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGEIF equivalent in excel 2000
You can use this link:
http://excel-queries.blogspot.com/ Thanks... "JE McGimpsey" wrote: One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =AVERAGE(IF(A1:A100="set location",B1:B100)) In article .com, flumpuk 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
AVERAGEIF equivalent in excel 2000
"Excel_Learner" wrote: You can use this link: http://www.excel-queries.blogspot.com/ Thanks... "JE McGimpsey" wrote: One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =AVERAGE(IF(A1:A100="set location",B1:B100)) In article .com, flumpuk 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 |
| Reply |
| 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 | |||
Hybrid Mode
