使用無敵公式,按CTRL+SHIFT+ENTER確定輸入,HI裡面已解決!
=SUM(INDIRECT(MID(ADDRESS(1,COLUMN(),2),1,FIND("$",ADDRESS(1,COLUMN(),2))-1)&IF(INDEX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1)),MAX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1))*((INDIRECT("G1"):INDIRECT("G"&ROW()-1))="使用情況總計")))+1=2,1,INDEX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1)),MAX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1))*((INDIRECT("G1"):INDIRECT("G"&ROW()-1))="使用情況總計")))+1)&":"&MID(ADDRESS(1,COLUMN(),2),1,FIND("$",ADDRESS(1,COLUMN(),2))-1)&ROW()-1,1))
使用無敵公式,按CTRL+SHIFT+ENTER確定輸入,HI裡面已解決!
=SUM(INDIRECT(MID(ADDRESS(1,COLUMN(),2),1,FIND("$",ADDRESS(1,COLUMN(),2))-1)&IF(INDEX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1)),MAX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1))*((INDIRECT("G1"):INDIRECT("G"&ROW()-1))="使用情況總計")))+1=2,1,INDEX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1)),MAX(ROW(INDIRECT("G1"):INDIRECT("G"&ROW()-1))*((INDIRECT("G1"):INDIRECT("G"&ROW()-1))="使用情況總計")))+1)&":"&MID(ADDRESS(1,COLUMN(),2),1,FIND("$",ADDRESS(1,COLUMN(),2))-1)&ROW()-1,1))