I have an excel spreadsheet that I'm using as a performance scorecard. I'm
calculating a weighted average with Sumproduct. In the range of cells for the
sumproduct formula are cells with text. The text cells are merged to create a
comments box.
The issue is when you reach a certain number of characters in the comments
box the sumproduct cell changes to #VALUE!
Additionally, if the comments box is formatted as Text, when it reachs that
same number of characters, the cell displays ####### across the entire merged
cell. However, if the format is changed to General it displays the text again.
What am I missing?

I would like the comments box character limit to be unlimited or at least as
long as it's still viewable, and without impacting the sumproduct cell value.

It might be helpful if I could send you a copy of the scorecard.