



圖表復選框應用:
日期:=IF(ISERR(-(H$1&-ROW(H1))),"",2023&-H$1&-ROW(H1))
指標:=IF(G1=TRUE,"消費"," ")
指標數(shù)值:=IF($I$1="消費",SUMIF('日消費 '!$C:$C,H2,'日消費 '!$F:$F)," ")
圖表復選框應用:
日期:=IF(ISERR(-(H$1&-ROW(H1))),"",2023&-H$1&-ROW(H1))
指標:=IF(G1=TRUE,"消費"," ")
指標數(shù)值:=IF($I$1="消費",SUMIF('日消費 '!$C:$C,H2,'日消費 '!$F:$F)," ")