median not working

[anuradhagrewal]

Hi Guys
I need your help
The file is here
I am trying to figure out the median pay with respect to Age location and subject taught (MEDIAN worksheet)
Can you guys please help me out
The file is attached here.


Regards

Anu

 

[AhoyNC]

Try something like this.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
=MEDIAN(IF($E$3:$E$878="ENGLISH",IF($D$3:$D$878="NCR",IF($C$3:$C$878>=45,($F$3:$F$878)))))

 

[anuradhagrewal]

Try something like this.
This is an array formula and must be entered with CTRL-SHIFT-ENTER.
=MEDIAN(IF($E$3:$E$878="ENGLISH",IF($D$3:$D$878="NCR",IF($C$3:$C$878>=45,($F$3:$F$878)))))

Its not working showing zero when I add the given formula to G3

 

[Peter_SSs]

First fix the error in cell C767 of 'MAIN' then try these (all confirmed with Ctrl+Shift+Enter

In cell E4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!C$3:C$878=D4,MAIN!F$3:F$878))

In H4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!D$3:D$878=G4,MAIN!F$3:F$878))

In K4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!E$3:E$878=J4,MAIN!F$3:F$878))

 

[anuradhagrewal]

First fix the error in cell C767 of 'MAIN' then try these (all confirmed with Ctrl+Shift+Enter

In cell E4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!C$3:C$878=D4,MAIN!F$3:F$878))

In H4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!D$3:D$878=G4,MAIN!F$3:F$878))

In K4 of 'MEDIAN' and copy down

=MEDIAN(IF(MAIN!E$3:E$878=J4,MAIN!F$3:F$878))

I have done exactly as you have suggested
But still the output is not coming
U can see the file here

 

[Fluff]

You have still got the #VALUE! error in C767 & you have not confirmed any of the formula with Ctrl Shift Enter as Peter said.

 

[anuradhagrewal]

You have still got the #VALUE! error in C767 & you have not confirmed any of the formula with Ctrl Shift Enter as Peter said.

Please download the file I have done as suggested but still there is no median being calculated

 

[Fluff]

I have downloaded the file, that how I know you have not done what Peter suggested.

 

[anuradhagrewal]

Please download the file I have done as suggested but still there is no median being calculated

May I request you to do the changes and post the file here
Much obliged

 

[Fluff]

I cannot post the file here. Just follow the instructions that Peter gave.