Try
=IF($C3="","",SUMIF(OFFSET($A$2,MATCH(LOOKUP(10^10,$C$2:$C2),$C$2:$C2,0),0,ROWS($1:1)+2-MATCH(LOOKUP(10^10,$C$2:$C2),$C$2:$C2,0)-1),">0"))
Try
=IF($C3="","",SUMIF(OFFSET($A$2,MATCH(LOOKUP(10^10,$C$2:$C2),$C$2:$C2,0),0,ROWS($1:1)+2-MATCH(LOOKUP(10^10,$C$2:$C2),$C$2:$C2,0)-1),">0"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks