Forum Discussion
sumproduct #value error
Even though I ignore null values, I get #value error.
Can you help me with the cause or solution?
First, the formula can be shortened:
=SUM(--((O13:V13-{0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9})>0))And second, the cells O18:R18 contain text. And Excel can't perform subtraction on text.
Hello, I'm getting the same error again.
This time I wrote the entire Formula.
= TOPLA.ÇARPIM( ( İLKEŞLEŞEN(SOLDAN($O$12:$V$12;3);"QoQ";$B$4;"YoY";$A$4)<(O13:V13-{0\0,1\0,2\0,3\0,4\0,5\0,6\0,7\0,8\0,9}))*(O13:V13<>""))- TOPLA.ÇARPIM( ( İLKEŞLEŞEN(SOLDAN($O$12:$V$12;3);"QoQ";$B$4;"YoY";$A$4)>(O13:V13+{0\0,1\0,2\0,3\0,4\0,5\0,6\0,7\0,8\0,9}))*(O13:V13<>""))- Well, that is because you still have text in O18:R18. Remove it!
