Median / If (and Mode / If) not working

[chrono2483]

Hey team,

Looking for additional assistance. My formula:

=MEDIAN(if('Review/Analysis'!A6:A24="TRUE",'Review/Analysis'!O6:O24))
&
=ArrayFormula(MEDIAN(if('Review/Analysis'!A6:A24="TRUE",'Review/Analysis'!O6:O24))) [tried it as an array as well]

My issue is that it does not return any results even though the parameters are met. The error I get is: MEDIAN has no valid input data.

My Goal: I'm trying to return the median (and mode) value of a range of numbers, based on the fact that the respective column A = "TRUE". I understand if only one value is selected as TRUE, it shouldn't return anything, but I've tried where multiple rows in Column A = "TRUE", but still the formula doesn't work.

Hope this is descriptive enough. Else I can create a user friendly example to share.

Thank you.

 

[Eric W]

First, this thread really should be in the "General Discussion and Other Applications" forum, since you are looking at Google Sheets. The ArrayFormula is not an Excel function.

I don't know much about Google Sheets, except that it's similar to Excel, but with some significant differences. One thing I'd try is to remove the quote marks from around TRUE. There's a difference between "TRUE" (a text value of 4 letters), and TRUE (a Boolean value). So your formula might be comparing a text value in the formula with a Boolean value on the sheet.