sry if my word confuse you, your formula give different result with what i want.

what i want is

name item shop qty
vian cylinder aa 5
vian cylinder ab 0
vian cylinder ac 7

the result will 2

vian cylinder aa 5
vian cylinder aa 4
vian cylinder ab 5
vian cylinder ac 2

the result will 3