=Median(if(A1:A20="AA",B1:B20))
entered with Ctrl+shift+enter rather than just enter since this is an array
formula

column A contains the conditional data and column B the numbers to use for
the median

=Median(if((A1:A20="AA")*(C1:C20="CC"),B1:B20))
entered with Ctrl+shift+enter rather than just enter since this is an array
formula

shows how to have conditions in Column A and C

--
Regards,
Tom Ogilvy


"AnandaSim" wrote in message
oups.com...
I'm working with an dynamically defined, continous block of cells. The
requestor doesn't want to weed out or filter out unwanted records,
they fit a criteria. So I will have to use the domain aggregate
functions DAVERAGE, DSTDEV etc... However, there is no DMEDIAN. Any
tips to creating my own Dfunction?

Thanks Muchly,

Ananda