Avg if, median if

The Sum if Function works great. I was wondering if we have a way to perform Avg If or Median If?

Hey Zack!

We do not have a specific AvgIf() or MedianIf() function but it is pretty easy to produce this using an Avg() and an If() function! The equation below is how you would make an AvgIf() formula and this could be used the same with Median.

Avg(If([Column]=“Value”,[Amount]))

1 Like