SUMPRODUCT is driving me insane

[Jon von der Heyden]

Hi there,

I have used a series of sumproducts and I've never encountered this. The sumproduct is drivin by two criteria and finally adds up a tax amount.

=SUMPRODUCT(--(Address=$D62),--(Mapping_Period=F$7),Tax_Amount)

Address range: =Data!$X$2:$X$3729
Mapping_Period: =Data!$T$2:$T$3729
Tax_Amount: =Data!$S$2:$S$3729

Address is a 5 digit code, all are recognised values.
Mapping_Period is alpha-numeric (e.g. q102).
Tax_Amount is in currency, all are recognised values.

My formulae are spitting out #VALUE!. Any idea why?
Unfortunately I can't upload the sheet as I'm working on a restricted PC, won't allow downloads.

Help very greatly appreciated.

Jon

 

[KenWright]

If you select your entire range, do Edit / Go To / Special / Tick Formulas and then within that uncheck everything except errors, and then hit OK, does it find anything?