average with conditions
Hi Friends,
I want to calculate the Average from the list of name and numbers(Horizontal list).
e.g. I have 10 names like abc, bbc, ddc, xyz and they have their own earned numbers now what I want is:-
=if("A1:z1"="abc", average("A1:z1"),0) - now this average will show me abc's earned average numbers.
is it possible.......???
Please help.
Regards,
Ravi
Try
=Average(if(A1:z1="abc", A2:Z2))
confirmed with CTRL+SHIFT+ENTER
or
=Sumif(A1:z1,"abc", A2:Z2)/Countif(A1:z1,"abc")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
The ranges in your formula make no sense (ie A1:Z1 can not contain both names and numbers) ... if we assume then that text strings are in row 1 and values in row 2 then:
Or use a pivot table of course...
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I made same assumption
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks