合併格計算人數與戶數 (10002)


H2:H22=IF(B2>0,-LOOKUP(9,-MATCH(1=1,B3:B$23<>"",{1,0}))&"人","")


I2:I22=IF(H2="","",COUNT(0/FREQUENCY(OFFSET(G2,,,LEFTB(H2,2)),OFFSET(G2,,,LEFTB(H2,2))))&"户")


留言