Column A lists the group assigned to complete research assignments (e.g., A or B), and column D lists the number of days between the assignment of a project and its completion. Is there a formula that will allow me to calculate the median for each group without just filtering out the groups, pasting them into a new worksheet, and calculating the median?
=SUMIF(A4:A20;G23;B4:B20)-SUMIF(A4:A20;G23;C4:C20)
G23 value is A
if you need the average, divide formula with countif
Both confirmed with C+S+E (as array formula):
=MEDIAN(IF(A2:A20="B",F2:F20))
or
=MEDIAN(IF(FullData[Dept]="B",FullData[Median Research Time (Days)]))
See attached.
Last edited by eibi; 11-18-2016 at 03:12 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks