software

codevalue Avalue Bvalue Cvalue Dtest
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 test25,950

1 9,250
2 14,500
3 2,200
Total test25,950The quot;testquot; field contains =MAX(0,B2-C2-D2-E2) Is there a function that will
sum that formula by the quot;codequot; field without using the quot;testquot; field?
--
Jim


Perhaps this

=SUMPRODUCT(--(A2:A7=1),--(B2:B7-C2:C7-D27-E2:E7gt;0),B2:B7-C2:C7-D27-E2:E7)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=510283Very cool daddy!

I use similar sumproduct configurations but couldn't figure this one out.

Thanks.
--
Jimquot;daddylonglegsquot; wrote:

gt;
gt; Perhaps this
gt;
gt; =SUMPRODUCT(--(A2:A7=1),--(B2:B7-C2:C7-D27-E2:E7gt;0),B2:B7-C2:C7-D27-E2:E7)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=510283
gt;
gt;