Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,907
- Office Version
- 365
- Platform
- Windows
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.
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
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.
Code:
=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