sum until hitting blank cell

[pinguis]

ScreenShot001.png

Hello there

This is a report that I am doing to check the sales of each product.

In the image there are three products under C:Item No. For each product, I need to cross check whether the sum of K:Quantity matches M:Received, e.g. sum of K2:K4=M5, K6:K16=M17, K18:K21=M22.

In short, I would like to find a formula that adds up the values under K until it hits a blank cell, and starts over with the one underneath.

I tried to find something similar in the forum but cant seem to get anything similar.

I would appreciate if anyone has any idea how I can get this done easily.

Thank you!

[:) Sixthsense :)]

In M2 cell

Please Login or Register  to view this content.

Drag it down...

[Ace_XL]

In M2 use

Please Login or Register  to view this content.

Copy down

[benishiryo]

hi pingus, welcome to the forum. i suggest you upload an sample Excel file next time instead of a picture. an alternative if your data starts from row 2:
=IF(K2<>"","",SUMIF($C$2:C2,C2,$K$2:K2))

[kvsrinivasamurthy]

pl see the attached file with formula in M column.

[Teethless mama]

@kvsrinivasamurthy, M2: =IF(K2="",SUM(K1:INDEX($K1:K$2,MAX(IF($K1:K$2="",ROW($K1:K$2)-1,"")))),"") CSE


Try to use the one below. It looks shorter and more elegant without array enter

M2: =IF(K2="",SUM(K$2:K2)-SUM(M$1:M1),"")

Normally Enter

[Teethless mama]

@pinguis. Base on your sample, the formula can be really simple.

M2: =IF(K2="",SUMIF(C:C,C2,K:K),"")

copy down as far as needed