Formula getting #value error. Can't detect how to fix.

[MaryCarver]

I have written the below formula and it is coming up with a #value error. I traced the errors and the data format match's all other cells. I can't figure out what I need to do to resolve this error. Any Help, please.

=SUMPRODUCT(--(employee_name=A4),--(date>=B4),--(date<=C4),--denomination)

Defined Names:
employee_name = =March:August!$B$3:$B$600
date = =March:August!$D$3:$D$600
denomination = =March:August!$C$3:$C$600

Error:
See Attachement

[martindwilson]

maybe an excel workbook instead of a doc? but you cant use sumproduct like that

[MaryCarver]

It is a Excel Work Book.

[MaryCarver]

I'm trying to create a 3D formula. When I look up 3D formulas it lists the Sum Product as okay to use with a 3D formula.

Initially I tried this formula, but I need to include all worksheets in the formula. The only way I could think to do that is through a 3D formula.

=SUMPRODUCT(--(March!B$3:March!B$564=A3),--(March!D$3:March!D$564>=B$3),--(March!$D3:March!$D564<=C$3),March!C$3:March!C$564)

[martindwilson]

docx is not excel! and afaik
SUM,AVERAGE, AVERAGEA, COUNT, COUNTA, MAX, MAXA, MIN, MINA, PRODUCT, STDEV,
STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA, SMALL, LARGE, RANK,
MEDIAN, PERCENTILE, QUARTILE, TRIMMEAN, SKEW, AVEDEV, DEVSQ,
SUMSQ are about all that accept 3d,
if you know sumproduct does could you show your source?