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? |
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? |
=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? |
All times are GMT +1. The time now is 11:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com