A couple of questions...

1) Did you select B2 on your chart/matrix sheet before defining the
references?

2) Did you change the reference in both formulas from Sheet1 to the
actual name of the sheet containing your chart/matrix?

If these check out, I'd be happy to either look at your file or send you
a sample file.

In article ,
"Sam via OfficeKB.com" wrote:

Hi Domenic,

Thank you for assistance.

I'm getting #N/A error in all cells except where both criterion are the same
numeric value and the Formula returns blank / empty cell as expected. I'm not
sure why the cells are returning the #N/A error: the criteria pair of values
will somtimes be consecutive but more often not.

Can you think of anything that may be causing the errors?

Cheers
Sam