Forum Discussion
I'm having trouble creating a MEDIAN(IF(AND function in excel.
I'm trying to create a function that returns a median of an array when two criterion are met. The function works if I do a MEDIAN(IF( statement with one criterion. However, as soon as I change it to ...
=MEDIAN(IF((B2:B9="a")*(A2:A9=6),C2:C9))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.