this works:

```
{=MEDIAN((Table1[MonthFinish]=201012)*(Table1[Days]))}
```

but if I put 201012 into cell A3, this doesn't done work:

```
{=MEDIAN((Table1[MonthFinish]=A3)*(Table1[Days]))}
```

when i do Evaluate Formula on the 2nd one...I see that there are double quotes about the 201012 that was pulled from A3...like so:

```
{=MEDIAN((Table1[MonthFinish]="201012")*(Table1[Days]))}
```

and as such, all the 201012s pulled from the MonthFinish row come back as FALSE when compared to "201012" (ie, 201012="201012" ) where as they come back as TRUE when I hard code 201012 as it shows up as 201012=201012.

How do I get Excel to not put those quotes around the number?

`{=MEDIAN((Table1[MonthFinish]=VALUE(A3))*(Table1[Days]))}`

. I have not tested it. – wilson Dec 30 '10 at 2:54