Snasui Excel Forum

Hi Dear,
I need your help for a query.
I want to sum values between Order Numbers and input in cell C align with order number and return last value aligned with order number and input in cell D.
I don't want to fill blank with above cell and do the calculation.
The expected result also provided in column C and D.

Is it possible to do so?

Best wishes

Please update your excel version, see the link below.

http://snasui.com/viewtopic.php?f=6&p=103177#p103177

I use Excel 2013

Try with these formulas.

1. C2
   =IF(A2<>"",SUM(OFFSET(B2,0,0,SMALL(FREQUENCY(IF($A$2:$A$14="",ROW($A$2:$A$14)),IF($A$2:$A$14<>"",ROW($A$2:$A$14))),COUNTIF(A$2:A2,"<>")+1)+1)),"")
   Enter > Copy down
2. D2
   =IF(A2<>"",OFFSET(B2,SMALL(FREQUENCY(IF($A$2:$A$14="",ROW($A$2:$A$14)),IF($A$2:$A$14<>"",ROW($A$2:$A$14))),COUNTIF(A$2:A2,"<>")+1),0),"")
   Enter > Copy down