Multiple if statements within median forumla

Hi there,

I'm putting together a template of formulas to break down a pile of research data on salary and employment conditions globally.

I've managed to figure out a large chunk of it however I've been stonewalled.

The formula I used for breaking down median salaries is: =MEDIAN(IF(F2:F818=A823,IF(Q2:Q818=B824,IF(O2:O818=D822,H2:H818))))
This gives median salary and breaks down by country, size of the company, and male or female.

I'm trying to start a new section using the same formula but adding an additional IF statement - this is to further break down the research by years of experience (all other conditions remain)

I'm using =MEDIAN(IF(F2:F818=A852,IF(Q2:Q818=B853,IF(O2:O818=C854,IF(L2:L818=D851,H2:H818)))))

For the life of me I can't see what I am doing wrong but it is only coming up with #NUM!

I wondered if there is a limit on the number of IF statements?

Another thought is perhaps it just could not handle different words? This would explain why I can't use the same formula to pull out New Zealand data... although Hong Kong worked fine so I'm lost.

Sorry - I'm completely new at this.

Excel does have a limit on the number of IFs you can next: that number is 7, so you're fine there.

Looking at that I'd prefer to use an AND, but it is an array formula, which don't like AND / OR, so you're stuck there, I guess.

Well, it could be that there's simply nothing in the range that matches all four criteria; MEDIAN delivers a #NUM! error when array has zero elements.