回答編集履歴

一部修正

2021/04/14 05:14

投稿

スコア3002

test CHANGED Viewed

@@ -10,16 +10,16 @@
 - 括弧の数を揃える
-`=Query(IMPORTRANGE("1CBzSNmoxcNEHevT2KmMgalsMINJZ84rWUhT2nIiGLX0","日経平均株価!$A$18024:D"),select D where A = date '"&text(A366,"YYYY-MM-DD")')`
+`=Query(IMPORTRANGE("シートID","日経平均株価!$A$18024:D"),select D where A = date '"&text(A366,"YYYY-MM-DD")')`
 ↓
 - Query内の "(ダブルクォート) と & を見直す (selectの前の "がなくて最後も閉じれてないです)
-`=Query(IMPORTRANGE("1CBzSNmoxcNEHevT2KmMgalsMINJZ84rWUhT2nIiGLX0","日経平均株価!$A$18024:D"),"select D where A = date '"&text(A366,"YYYY-MM-DD")&"'")`
+`=Query(IMPORTRANGE("シートID","日経平均株価!$A$18024:D"),"select D where A = date '"&text(A366,"YYYY-MM-DD")&"'")`
 ↓
 - 列の指定を A,Dではなく Col1,Col4 に修正(importrangeで参照した時はこっち)
-`=Query(IMPORTRANGE("1CBzSNmoxcNEHevT2KmMgalsMINJZ84rWUhT2nIiGLX0","日経平均株価!$A$18024:D"),"select Col4 where Col1 = date '"&text(A366,"YYYY-MM-DD")&"'")`
+`=Query(IMPORTRANGE("シートID","日経平均株価!$A$18024:D"),"select Col4 where Col1 = date '"&text(A366,"YYYY-MM-DD")&"'")`