FILTER関数で期間を絞る場合 =FILTER(A2:Q46,(Q2:Q46>=T1)*(Q2:Q46<=U1)*(G2:G46=T20),"データなし") '全体参照 '日付参照 '条件参照 =FILTER(Sheet1!dummy,(Sheet1!dummy[有効期限]>=A1)*(Sheet1!dummy[有効期限]<=B1)*(Sheet1!dummy[血液型]=C１),"データ…