CODEWITHSUNDEEP
excelexcel-formulaexcel-2010spreadsheet
user2051347
user2051347

Reputation: 1669

Median of specific transactions

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!

Upvotes: 1

Views: 34

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

something like this should work:

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

and press CTRL+SHIFT+ENTER to evaluate it

Upvotes: 3

Related Questions