SUMPRODUCT formula not working

[kitsa]

Hi,
I'm having issue with my formula for SUMPRODUCT. It give me the figures I want, but when I put in a text in Column "L" it come up as #VALUE!, unsure why. Is anyone able to explain this or is there something I can do to overcome this? please check uploaded image, as this may help?

=SUMPRODUCT(('ESS Inv Data Entry'!$D$16:$D$59=Invoice!B18)*('ESS Inv Data Entry'!$J$14:$W$14=$G$16)*'ESS Inv Data Entry'!$J$16:$W$59)

Thanks in advance.

 

[Peter_SSs]

For that cell you have put "test" in,
- what sheet is it in?
- what row is it in?

 

[kitsa]

It's on the image. Sheet 1 called "ESS Inv Data Entry" on row 14.

 

[Peter_SSs]

It's on the image.

Sorry, I couldn't see the sheet name on any of the images or the the row numbers on the first or third image, hence my question.

Are you sure that "test" cell is in L14 and not L16? I'm asking because this part of your formula
('ESS Inv Data Entry'!$J$14:$W$14=$G$16)
by my best guess appears to be trying to match "E" in the row 2 rows above the "test" cell. Is that the case?