code value A value B value C value D test
1 5,000 250 5,000 0
1 10,000 250 500 9,250
2 20,000 5,000 500 14,500
3 5,000 500 600 5,000 0
3 10,000 7,000 800 2,200
3 20,000 30,000 0
Total test 25,950

1 9,250
2 14,500
3 2,200
Total test 25,950


The "test" field contains =MAX(0,B2-C2-D2-E2) Is there a function that will
sum that formula by the "code" field without using the "test" field?
--
Jim