#N/A error across my entire worksheet

[leeval]

I created a spreadsheet/graph/table workbook with formulas all correctly laid out.
This is with the intention of extracting a report from my CRM system and pasting it into sheet 3.

The plan was for the tables and graphs to populate themselves based on that data. I tested it with todays list, and it worked fine. I demonstrated it to my senior, and it worked fine too.

So how come when I tedst it again using different sample lists, it shows up as #N/A across the board?

Any advice appreciated

 

[Matt Rogers]

Hi.

It's difficult without your formula.

Maybe it helps:
=IF(ISERROR(YourFormula),"",YourFormula)

 

[leeval]

Hi.

It's difficult without your formula.

Maybe it helps:
=IF(ISERROR(YourFormula),"",YourFormula)

There are a few:

=AVERAGE(IF('List'!$Y$2:$Y$999="England",'List'!$X$2:$X$999))

shift-ctrl entered

=SUMPRODUCT(--('List'!$Y$2:$Y$999="England"),--('List'!$T$2:$T$999="pass"))

=SUMPRODUCT(--('List'!$Y$2:$Y$999="England"),--('List'!$O$2:$O$999>A33))

All give #N/A error