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".
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".
Excel Formula:
=SUMPRODUCT(($A$3:$A$12=N3)*($C$2:$J$2=$P$2)*$C$3:$J$12)