| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging numbers in query.
Oopsie.
Thanks for the correction. Bob Phillips wrote: plus another trailing bracket -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dave Peterson" wrote in message ... =average(if(left(a1:a99,20)="TMMKV6 Engine Assy11",b1:b99) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. Duser wrote: I am currently pulling a query into Microsoft Excel and I need to create a function that averages all cells from a specific month. So i need to have one cell that searchs all the queried data and pulls every number for a specific plant and month in june and then averages all the numbers it finds. For example below... I could just say =averge(B1:B5) except the range will increase every month, and then every year. So I am looking for a function that says look for TMMKV6 Engine Assy for every month 11 regardless of the year. Each month the query will run the averages for the new month should change and the old one's will only change once every year. A B TMMKV6 Engine Assy112005 0.86621058 TMMKV6 Engine Assy112004 0.850701809 TMMKV6 Engine Assy112003 0.805216908 TMMKV6 Engine Assy112002 0.805999994 Thank you for your help. -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Averaging the top 2/3 highest numbers | Excel Worksheet Functions | |||
| Averaging numbers but ignoring < and - entries | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
