| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumif function
Hello -
I have a range of names in column A and a range of ages in column B. How can I determine the average age per unique name? |
|
#2
|
|||
|
|||
|
Use this formula in C1 and copy down to bottom of your range:
=SUMPRODUCT(--($A$1:$A$1000=A1),--($B$1:$B$1000))/SUMPRODUCT(--($A$1:$A$1000=A1),--($B$1:$B$1000<"")) -- Regards, Dave "dnm" wrote: Hello - I have a range of names in column A and a range of ages in column B. How can I determine the average age per unique name? |
|
#3
|
|||
|
|||
|
=AVERAGE(IF(NameRange=Name,AgeRange))
which must be confirmed with control+shift+enter, not just with enter. Note also that this type of formulas do not admit whole column refernces like A:A as range. dnm wrote: Hello - I have a range of names in column A and a range of ages in column B. How can I determine the average age per unique name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| SUMIF function | Excel Worksheet Functions | |||
| help with "criterea" in the sumif function | Excel Worksheet Functions | |||
Linear Mode
