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?
Thanks in advance.
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?
VBA Code:
=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.