{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fswfz.hatenablog.com%2Fentry%2F2023%2F07%2F23%2F191247\" title=\"Spreadsheet\u306eQUERY\u3067\u30d8\u30c3\u30c0\u3092\u524a\u9664\u3059\u308b - notebook\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","blog_title":"notebook","type":"rich","version":"1.0","author_url":"https://blog.hatena.ne.jp/swfz/","categories":["SpreadSheet"],"blog_url":"https://swfz.hatenablog.com/","description":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u4f55\u304b\u3057\u3089\u307e\u3068\u3081\u305f\u308a\u3057\u3066\u3044\u308b\u3068QUERY\u3092\u4f7f\u3046\u3053\u3068\u304c\u591a\u304f\u306a\u308b \u30c7\u30d5\u30a9\u30eb\u30c8\u3060\u3068\u30d8\u30c3\u30c0\u884c\u3082\u51fa\u529b\u3055\u308c\u308b\u306e\u3067\u3001\u305d\u308c\u3060\u3068\u4f7f\u3044\u3065\u3089\u3044\u30b1\u30fc\u30b9\u304c\u3042\u308b \u305d\u308c\u3092\u306a\u304f\u3057\u3066\u4f7f\u3044\u3084\u3059\u304f\u3059\u308b \u7d50\u8ad6 LABEL ${\u5217\u306e\u540d\u524d} '' \u3092QUERY\u306e\u6700\u5f8c\u306b\u3064\u3051\u308b \u4f8b \u307e\u305a\u666e\u901a\u306b\u4f7f\u3063\u305f\u5834\u5408 \u3053\u3093\u306a\u611f\u3058\u306e\u30c7\u30fc\u30bf\u304c\u3042\u3063\u305f\u3068\u304d\u306b I2\u306e\u30af\u30a8\u30ea\u306e\u4e2d\u8eab =QUERY(A2:C5,\"SELECT SUM(B)\") K2\u306e\u30af\u30a8\u30ea\u306e\u4e2d\u8eab =QUERY(A1:C5,\"SELECT SUM(B)\") \u30c7\u30fc\u30bf\u7bc4\u56f2\u306b\u30d8\u30c3\u30c0\u884c\u3092\u5165\u308c\u308b\u5165\u308c\u306a\u3044\u3067\u591a\u5c11\u51fa\u529b\u304c\u304b\u308f\u308b\u304c\u5217\u540d\u304c\u8868\u793a\u3055\u308c\u3001QUERY\u306e\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u304c\u51fa\u529b\u3055\u308c\u308b \u30d8\u30c3\u30c0\u884c\u3092\u8868\u793a\u3055\u305b\u306a\u3044\u2026","provider_name":"Hatena Blog","author_name":"swfz","provider_url":"https://hatena.blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/swfz/20230723/20230723191225.png","published":"2023-07-23 19:12:47","title":"Spreadsheet\u306eQUERY\u3067\u30d8\u30c3\u30c0\u3092\u524a\u9664\u3059\u308b","height":"190","url":"https://swfz.hatenablog.com/entry/2023/07/23/191247"}