Error problem

[David Biddulph]

So, if you are getting #N/A as an answer, you have #N/A in at least one of
the cells referenced in your formula. The table icon means, as help told
you, "that the cell "is referenced by a cell on another worksheet or
workbook". ". You therefore need to go to the worksheet named "Tables", and
on that sheet you need to look in the range C2:E2958, as it is in that range
that you have at least one cell containing the N/A error.

You can find which row(s) the error is in by putting the formula
=ISNA(SUM(C2:E2)) in a spare cell in row 2, and copying down, and similarly
you can find out which column(s) by putting =ISNA(SUM(C2:C2958)) in a spare
cell in column C, and copying across.
--
David Biddulph

This is exactly what is in the cell:
=SUMPRODUCT(--(Tables!$C$2:$C$2958=$A4),--(Tables!$D$2:$D$2958=$B4),--(Tables!$E$2:$E$2958="Yes"))

 

[Ayo]

Thanks David. That was it.

So, if you are getting #N/A as an answer, you have #N/A in at least one of
the cells referenced in your formula. The table icon means, as help told
you, "that the cell "is referenced by a cell on another worksheet or
workbook". ". You therefore need to go to the worksheet named "Tables", and
on that sheet you need to look in the range C2:E2958, as it is in that range
that you have at least one cell containing the N/A error.

You can find which row(s) the error is in by putting the formula
=ISNA(SUM(C2:E2)) in a spare cell in row 2, and copying down, and similarly
you can find out which column(s) by putting =ISNA(SUM(C2:C2958)) in a spare
cell in column C, and copying across.

 

[Ayo]

Thanks David. That was it.

So, if you are getting #N/A as an answer, you have #N/A in at least one of
the cells referenced in your formula. The table icon means, as help told
you, "that the cell "is referenced by a cell on another worksheet or
workbook". ". You therefore need to go to the worksheet named "Tables", and
on that sheet you need to look in the range C2:E2958, as it is in that range
that you have at least one cell containing the N/A error.

You can find which row(s) the error is in by putting the formula
=ISNA(SUM(C2:E2)) in a spare cell in row 2, and copying down, and similarly
you can find out which column(s) by putting =ISNA(SUM(C2:C2958)) in a spare
cell in column C, and copying across.