THREED and text

[trone77]

Now when I use Threed with the formula below with it always returns 0.

=SUMPRODUCT(--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$B$8:$B$38)="Sun"),--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$C$8:$C$38)=4),--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$D$8:$D$38)=8),--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$E$8:$E$38)=8))


However if I remove the '--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$B$8:$B$38)="Sun")'...so just numbers and no text, it returns the correct answer.

=SUMPRODUCT(--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$C$8:$C$38)=4),--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$D$8:$D$38)=8),--(THREED('[All Months.xlsx]Jan 00:Dec 11'!$E$8:$E$38)=8))

Are there certain provisions with text and the THREED syntax?