Hi,

If you are using Office 2003, then you should have ticked "Extend data range
formats and formula" under the edit tab in "options" under the "Tools" menu.

If it is ticked or if you are not using office 2003, then please use the
following array formula (Ctrl+Shift+Enter)

Assume following data is in the range J6:J10 and you have use the sum
funtion in cell J12.

Use the following formual in cell J12,

=SUM(J6:OFFSET(J6,COUNT(J$7:J11),0))

Regards,

Ashish Mathur

"zahoulik" wrote:


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?


--
zahoulik