I'm trying to add some sort of cross-check to my spreadsheet. I need to make a function that compares the sum of a list of numbers and another number (taken from another sheet). I know something like =IF(SUM(E5:E9)=E4,"CORRECT","WRONG") can help, but what if I insert a new line of info at E:10? That function cannot help. Any ideas?