| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Statistics (average of multiple divisions)
Hello everybody,
I try to figure out a "one-cell" formula that could make a following calculation: From B6 to AZ6 I have one range of numbers From B7 to AZ7 I have another range (numbers as well) What interests me is to find an average of B6/B7, C6/C7, D6/D7 until AZ6/AZ7. For sure, I can make a long formula that makes 1000 miles to write:-), but I'm sure there is an easier way... Thanks a lot for your help on this! Mark |
|
#2
|
|||
|
|||
|
Hi Mark,
If all of the divisor cells have a value then =AVERAGE(B6:AZ6/B7:AZ7) If some are empty, or you are not sure then =AVERAGE(IF(B7:AZ7<0,B6:AZ6/B7:AZ7)) Both are array formulas, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "markx" wrote in message ... Hello everybody, I try to figure out a "one-cell" formula that could make a following calculation: From B6 to AZ6 I have one range of numbers From B7 to AZ7 I have another range (numbers as well) What interests me is to find an average of B6/B7, C6/C7, D6/D7 until AZ6/AZ7. For sure, I can make a long formula that makes 1000 miles to write:-), but I'm sure there is an easier way... Thanks a lot for your help on this! Mark |
|
#3
|
|||
|
|||
|
Thanks Bob,
Worked perfectly for me! Thanks as well for underlining ARRAY thing, without this I would surely get wrong results.. Cheers, Mark "Bob Phillips" wrote in message ... Hi Mark, If all of the divisor cells have a value then =AVERAGE(B6:AZ6/B7:AZ7) If some are empty, or you are not sure then =AVERAGE(IF(B7:AZ7<0,B6:AZ6/B7:AZ7)) Both are array formulas, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "markx" wrote in message ... Hello everybody, I try to figure out a "one-cell" formula that could make a following calculation: From B6 to AZ6 I have one range of numbers From B7 to AZ7 I have another range (numbers as well) What interests me is to find an average of B6/B7, C6/C7, D6/D7 until AZ6/AZ7. For sure, I can make a long formula that makes 1000 miles to write:-), but I'm sure there is an easier way... Thanks a lot for your help on this! Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| averaging specific rows in multiple arrays | Excel Worksheet Functions | |||
| Weighted Avg - using values from multiple sheets | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Can I sum or average a range with more than 1 condition? | Excel Discussion (Misc queries) | |||
Linear Mode
