Calculating Median's with Multiple Conditions

[dmillerssa]

Hi:

Quick issue I'm hoping someone can help me with.

Since the Pivot function lacks a median calculation, I need to calculate some median's based off three conditions in a data sheet.

I found working formulas for 2 conditions, but not three.

Here is what the data like:

A B C D
1 PUG 2010 January 21.1


D would represent the column I need to calculate the median off off. A, B, C are the conditional columsn.

Any help on this formula?

Thank you!

 

[barry houdini]

Yes, there's no reason why that setup can't work with 3 or 4 or 5 or more criteria so I'd assume that you have something not matching when you think it should. Dates are often problematic as pplstuff suggests, do you have dates in column C formatted to look like 2010 January or is that text?

 

[pplstuff]

Check the the "PUG" values are not " PUG" or "PUG "

 

[dmillerssa]

Given I only had a few categories, I broke it up into a few different sheets and used the formula that worked.

Thanks for all the help!