谷歌作業表用復選框計數多個條件范圍-有解無憂

我試圖在勾選復選框后顯示 itemname image。如果勾選了兩次復選框，則該專案應顯示兩次 - 如果勾選了一個專案的所有復選框，則顯示 3 次。

當前功能不起作用：

ifna(filter(BT!A5:B,BT!C5:C),if({1,1},char(999)));
ifna(filter(BT!A5:B,BT!D5:D),if({1,1},char(999)));
ifna(filter(BT!A5:B,BT!E5:E),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!I5:I),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!J5:J),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!K5:K),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!O5:O),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!P5:P),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!Q5:Q),if({1,1},char(999)));
ifna(filter(Hyjal!A5:B,Hyjal!C5:C),if({1,1},char(999)));
ifna(filter(Hyjal!A5:B,Hyjal!D5:D),if({1,1},char(999)));
ifna(filter(Hyjal!A5:B,Hyjal!E5:E),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!I5:I),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!J5:J),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!K5:K),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!O5:O),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!P5:P),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!U5:U),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!V5:V),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!W5:W),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!Q5:Q),if({1,1},char(999)))}, 
countifs(Hyjal!C:W,true,BT!C:W,true),,2,1)

如果我為每張紙拆分功能并嘗試它，它就可以作業。

ifna(filter(Hyjal!A5:B,Hyjal!C5:C),if({1,1},char(999)));
ifna(filter(Hyjal!A5:B,Hyjal!D5:D),if({1,1},char(999)));
ifna(filter(Hyjal!A5:B,Hyjal!E5:E),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!I5:I),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!J5:J),if({1,1},char(999))); 
ifna(filter(Hyjal!G5:H,Hyjal!K5:K),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!O5:O),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!P5:P),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!U5:U),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!V5:V),if({1,1},char(999))); 
ifna(filter(Hyjal!S5:T,Hyjal!W5:W),if({1,1},char(999))); 
ifna(filter(Hyjal!M5:N,Hyjal!Q5:Q),if({1,1},char(999)))}, 
countif(Hyjal!C5:W37,true),,2,1)

對于我使用的表 BT

ifna(filter(BT!A5:B,BT!C5:C),if({1,1},char(999)));
ifna(filter(BT!A5:B,BT!D5:D),if({1,1},char(999)));
ifna(filter(BT!A5:B,BT!E5:E),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!I5:I),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!J5:J),if({1,1},char(999))); 
ifna(filter(BT!G5:H,BT!K5:K),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!O5:O),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!P5:P),if({1,1},char(999))); 
ifna(filter(BT!M5:N,BT!Q5:Q),if({1,1},char(999)))}, 
countif(BT!C5:Q73,true),,2,1)

因此，我嘗試將這兩個函式與結合起來countifs，將公式中的列標準范圍更改為 C:W，但它僅在檢查作業表 BT 中的專案后才顯示作業表 Hyjal 中的專案。不顯示來自 BT 本身的專案。

谷歌作業表用復選框計數多個條件范圍

轉載請註明出處，本文鏈接：https://www.uj5u.com/net/430969.html

標籤：排序谷歌表格复选框筛选计数

上一篇：什么是排名前3位二氧化碳資料的有效方法？

下一篇：如何使用隨機破壞關系的比較器進行排序？