记录一下,直接用
=COUNTIF(INDIRECT("RC[-"&COLUMN()-MATCH("*品牌*",$1:$1,0) &"]:RC[-1]",FALSE),"<>")-COUNTIF(INDIRECT("RC[-"&COLUMN()-MATCH("*品牌*",$1:$1,0) &"]:RC[-1]",FALSE),"xxxxxx")
记录一下,直接用
=COUNTIF(INDIRECT("RC[-"&COLUMN()-MATCH("*品牌*",$1:$1,0) &"]:RC[-1]",FALSE),"<>")-COUNTIF(INDIRECT("RC[-"&COLUMN()-MATCH("*品牌*",$1:$1,0) &"]:RC[-1]",FALSE),"xxxxxx")