double unary

Sumproduct() error messages

So you’ve just created a Sumproduct() formula with lots of parameters. You hit enter and you get #Value! — Hmm. You go about and inspect the formula, change a few things. Hit enter and you get #N/A — Hmm again. Wish you knew for what reason Sumproduct shows #Value! and for what reason it shows [...]