Franco <sjays <at> cox.net> writes: > > Let's say I have sales records for lots of transactions (represented by rows > in a spreadsheet). Three of the fields are geographic location, sales > price, and size. If I want to calculate the median price for just records > in a certain geographic area and a certain size, how would I write that > function? > The database functions would work for that. Unfortunately there is no DMEDIAN function, so you would have to combine DAVERAGE, DMIN and DMAX, which is ugly. SUMPRODUCT might suit, perhaps combined with MEDIAN.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
