"zahoulik" wrote:
=IF(SUM(E5:E9)=E4,"CORRECT","WRONG") can help,
but what if I insert a new line of info at E:10?

There may be more clever solutions, but my approach
is to simply ensure that the SUM() range includes blank
(or text) cells above and below the interesting range.
This is often the case anyway, for aesthetic reasons.

Bewa That can lead to confusing results, if you are
not careful. For example, suppose E4 and E10 are
always-blank cells, and you write SUM(E4:E10). That's
okay. But COUNT(E4:E10) gives a misleading result.
You would have to be careful to write COUNT(E4:E10) - 2.