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

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:

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


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.

1 Like

Following for update :slight_smile: