How to find Median, Max, or Min Conditionally in a Subtable


#1

I was able to calculate an average from figures in a subtable by dividing SUMIFS by COUNTIFS. But how can I calculate the Median, Max, or Min similarly?

In Excel, you can use a formula similar to the solutions here: https://www.mrexcel.com/forum/excel-questions/336449-how-calc-median-average-max-based-condition-like-sumif-kinda.html

Would there be a way to do this in Ragic?
Example: MEDIAN(IF(A1==‘0’,B1)) does not seem to work.


#2

Hi,

Currently, Ragic support MAX() and MIN() in subtables:

However, we haven’t supported MEDIAN() so far. I’ll report this to our developers for further discussion.


#3

Following for update :slight_smile: