Forum Discussion
sumproduct #value error
Even though I ignore null values, I get #value error. Can you help me with the cause or solution?
You had an apostrophe in every cell in the range O18:R18.
If you step through the formula with the formula evaluator, it is made very apparent:
There has to be an apostrophe there.
There is the formula under normal conditions. iferror(x-y)/y;"")
If you replace this formula with iferror((x-y)/y;0) it will be filled with "0" or "-", which is visually impossible.
There is the formula under normal conditions. iferror(x-y)/y;"")
If you replace this formula with iferror((x-y)/y;0) it will be filled with "0" or "-", which is visually impossible.