Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need "average" help
I am trying to calculate an average of numbers, based on who owns those
numbers. In summary, D4:D1000 will have a person's last name. M4:m1000 will have a number entered into it. I want to average M4:M1000 but only using the numbers that correspond with a single last name. For instance, the last name Smith appears in d4:d100; I want to average only those numbers associated with the Smith name. Also, I need to do this without sorting. My results are on another sheet in the workbook so my information is contained in sheet 1, but my formula (results) is located in sheet 2. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Average" Function in Excel | Excel Discussion (Misc queries) |