For anyone else that is having these problems, here's a revised “if” block with only a few minor changes.

NOTE: I did NOT thoroughly test this yet but it solved the problems I was encountering.

Hi Tony,

Actually, after I posted my solution, I realized I wrote a custom formatter for percentages that was inserting the single space. Can't remember why exactly as it seemed to perform the same way when I took the single space out. Maybe it was a typo on my part.

I would think that if the cell value is null or, when the white space is trimmed, equals empty string, then the cell's value should not count towards the average.

At the very least, I think that null and empty string should not count – I think you could make a case either way about the trimming of whitespace.

Thanks!

– Joe

Yeah, that's why I was saying I think it could go either way.

As long as everything else works OK, the programmer can always “tweak” the values of the cells to get the grid to behave the way they want.

Thanks for fixing it so quickly!

– Joe