If value isn't correct and SUM(value) isn't correct, it's not clear what IS correct without sample data and expected results. Please read the first link in my signature to show how to post the data to the forum. You need to make sure that you're posting enough info to demonstrate the problem without overwhelming people. Based on your question, you probably don't need more than 10 rows.

Drew