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 [...]

Sumproduct() returns wrong results in Excel 2007

Working on a question submitted in an on-line forum the other day, I stumbled upon a phenomenon that threatened to do my head in. The asker of the question had attached her workbook to the post, created with Excel 2007. As of writing this, I am working mainly with Excel 2003 and the Excel 2010 [...]