Median of specific transactions

Question

I have the following sheet:

enter image description here

I would like to take the median for all rows with a K.

I know how to take the median of all transactions. The hard part for me is "search for K and take only this transactions".

Any recommendations how to solve this?

I appreciate your answer!

score 3 · Accepted Answer · answered Mar 06 '14 at 11:26

3

something like this should work:

=MEDIAN(IF(A2:A16="K",B2:B16))

and press CTRL+SHIFT+ENTER to evaluate it

answered Mar 06 '14 at 11:26

Dmitry Pavliv

Thx for your answer! However I am getting `0` for the median, which cannot be possible... btw I used this: `=MEDIAN(IF(A2:A16="K";B2:B16))` – user2051347 Mar 06 '14 at 11:29
1

have you pressed CTRL+SHIFT+ENTER to evaluate it, or just ENTER? – Dmitry Pavliv Mar 06 '14 at 11:30
yep have pressed it several times! Any recommendation how to evaluate it differently? – user2051347 Mar 06 '14 at 11:31

1 Answers1