r/excel • u/Szydlikj • 9d ago

MEDIANIF formula resulting in a VALUE! error solved

Hello again everyone. Reposting from last week after having tried some of your solutions to no avail. I am trying to calculate a median value from a subset of information. On Excel 2019 version 16.

The guide I followed suggested this format, but it returns a VALUE! error:

=MEDIAN(IF(L2:L200, “Same”, Y2:Y200))

Also tried your suggestion:

=MEDIAN(IF(L2:L200=“Same”, Y2:Y200))

Which outputs 0, but there are no 0s in the subset of data.

L column is checking for subset "Same", and Y column contains the number values I want the median for. Is it possible that the issue is because the values in Y column are the result of a formula?

Thanks in advance to all you wizards!

1 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

46 comments sorted by

View all comments

Show parent comments

1

u/PaulieThePolarBear 1438 9d ago

I just click the cell and enter the keys right?

The only difference between a regular formula and an array formula is that you use CSE to commit it rather than just enter. You type your formula as you would normally.

If so, CSE doesn't do anything in my version of excel.

What does "doesn't do anything" mean?

Please provide an image showing what you mean by this. This image should include row and column labels as well as the formula you entered visible in the formula bar. You should NOT be in edit mode on this cell.