Forum Discussion
Solved
Median and mode with criteria
Hi Can anyone tell me how to find the median and the mode of values with criteria? Here is an example of what I mean: On the left is a list of products, their colors and prices. On the ta...
=AVERAGE(IF(Table1[Color]=[Product color],Table1[Price]))
=MODE(IF(Table1[Color]=[Product color],Table1[Price]))
Is this what you are looking for? Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.
=AVERAGE(IF(Table1[Color]=[Product color],Table1[Price]))
=MODE(IF(Table1[Color]=[Product color],Table1[Price]))
Is this what you are looking for? Enter the formulas with ctrl+shift+enter if you don't work with Office365 or 2021.
Exactly, thank you!