Forum Discussion

Dineshja48's avatar
Dineshja48
Copper Contributor
May 31, 2023
Solved

Finding error while calculate median for a Groupby - array returns zero with other values.

I'm trying to calculate a median value at group by operation but not finding correct answer. In my example i've material and plant information and want to know the total spend median value at each ma...
  • HansVogelaar's avatar
    May 31, 2023

    Dineshja48 

    Try

     

    =MEDIAN(IF(($A$2:$A$11=A2)*($B$2:$B$11=B2),$D$2:$D$11))

     

    If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter

Resources