I just must be doing something wrong because the 2nd and 3rd rows returned a
value but the rest are zero.

"Max" wrote:

It should have worked. Probably your source data is not cleansed, and the
source col Q may contain text nums. Try this heavier duty adaptation of your
expression which takes care of all possibilities, array-entered:
=MEDIAN(IF(TRIM('Census by Title'!E$2:E$3251)=TRIM(A5),'Census by
Title'!Q$2:Q$3251+0))

Success, finally? Click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"SB Lee" wrote:
I created the pivot table as you stated and am using the following formula
but it is just bringing back o's. =MEDIAN(IF('Census by
Title'!E$2:E$3251=A5,'Census by Title'!Q$2:Q$3251))