| 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 |
| 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) | |||
Threaded Mode
