SUMPRODUCT error #value! when a column contains text and number

[kitsa]

Hi,
I have an issue with my code and I can't work out how to fix. The formula works when there is no text in a column "E", but when blank or just numbers, it works. How can I get this to work when there is text in column "E".

=SUMPRODUCT(($A$3:$A$12=N3)*($C$2:$J$2=$P$2)*$C$3:$J$12)

 

[SanjayGMusafir]

Hi,
I'm using Office Professional Plus 2016, how do I update?

Click on your profile Name above right - Do the changes and save