2023年10月15日日曜日

EXCEL 関数

 =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"C"&"8")&"13"&":"&INDIRECT("設定!"&"C"&"9")&"36")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"D"&"8")&"13"&":"&INDIRECT("設定!"&"D"&"9")&"36")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"E"&"8")&"13"&":"&INDIRECT("設定!"&"E"&"9")&"36")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"F"&"8")&"13"&":"&INDIRECT("設定!"&"F"&"9")&"36")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"G"&"8")&"13"&":"&INDIRECT("設定!"&"G"&"9")&"36"))
=SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"C"&"8")&"39"&":"&INDIRECT("設定!"&"C"&"9")&"67")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"D"&"8")&"39"&":"&INDIRECT("設定!"&"D"&"9")&"67")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"E"&"8")&"39"&":"&INDIRECT("設定!"&"E"&"9")&"67")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"F"&"8")&"39"&":"&INDIRECT("設定!"&"F"&"9")&"67")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"G"&"8")&"39"&":"&INDIRECT("設定!"&"G"&"9")&"67"))
=SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"C"&"8")&"9"&":"&INDIRECT("設定!"&"C"&"9")&"12"))+SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"C"&"8")&"68"&":"&INDIRECT("設定!"&"C"&"9")&"98")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"D"&"8")&"9"&":"&INDIRECT("設定!"&"D"&"9")&"12"))+SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"D"&"8")&"68"&":"&INDIRECT("設定!"&"D"&"9")&"98")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"E"&"8")&"9"&":"&INDIRECT("設定!"&"E"&"9")&"12"))+SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"E"&"8")&"68"&":"&INDIRECT("設定!"&"E"&"9")&"98")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"F"&"8")&"9"&":"&INDIRECT("設定!"&"F"&"9")&"12"))+SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"F"&"8")&"68"&":"&INDIRECT("設定!"&"F"&"9")&"98")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"G"&"8")&"9"&":"&INDIRECT("設定!"&"G"&"9")&"12"))+SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"G"&"8")&"68"&":"&INDIRECT("設定!"&"G"&"9")&"98"))
=SUM(D4:D6) =SUM(E4:E6) =SUM(F4:F6) =SUM(G4:G6) =SUM(H4:H6)
=SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"C"&"8")&"4"&":"&INDIRECT("設定!"&"C"&"9")&"4")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"D"&"8")&"4"&":"&INDIRECT("設定!"&"D"&"9")&"4")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"E"&"8")&"4"&":"&INDIRECT("設定!"&"E"&"9")&"4")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"F"&"8")&"4"&":"&INDIRECT("設定!"&"F"&"9")&"4")) =SUM(INDIRECT($B$4&"!"&INDIRECT("設定!"&"G"&"8")&"4"&":"&INDIRECT("設定!"&"G"&"9")&"4"))
=SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"13"&":"&INDIRECT("設定!"&"C"&"9")&"36")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"13"&":"&INDIRECT("設定!"&"D"&"9")&"36")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"13"&":"&INDIRECT("設定!"&"E"&"9")&"36")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"13"&":"&INDIRECT("設定!"&"F"&"9")&"36")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"13"&":"&INDIRECT("設定!"&"G"&"9")&"36"))
=SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"39"&":"&INDIRECT("設定!"&"C"&"9")&"67")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"39"&":"&INDIRECT("設定!"&"D"&"9")&"67")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"39"&":"&INDIRECT("設定!"&"E"&"9")&"67")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"39"&":"&INDIRECT("設定!"&"F"&"9")&"67")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"39"&":"&INDIRECT("設定!"&"G"&"9")&"67"))
=SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"9"&":"&INDIRECT("設定!"&"C"&"9")&"12"))+SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"68"&":"&INDIRECT("設定!"&"C"&"9")&"98")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"9"&":"&INDIRECT("設定!"&"D"&"9")&"12"))+SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"68"&":"&INDIRECT("設定!"&"D"&"9")&"98")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"9"&":"&INDIRECT("設定!"&"E"&"9")&"12"))+SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"68"&":"&INDIRECT("設定!"&"E"&"9")&"98")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"9"&":"&INDIRECT("設定!"&"F"&"9")&"12"))+SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"68"&":"&INDIRECT("設定!"&"F"&"9")&"98")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"9"&":"&INDIRECT("設定!"&"G"&"9")&"12"))+SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"68"&":"&INDIRECT("設定!"&"G"&"9")&"98"))
=SUM(D9:D11) =SUM(E9:E11) =SUM(F9:F11) =SUM(G9:G11) =SUM(H9:H11)
=SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"4"&":"&INDIRECT("設定!"&"C"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"4"&":"&INDIRECT("設定!"&"D"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"4"&":"&INDIRECT("設定!"&"E"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"4"&":"&INDIRECT("設定!"&"F"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"4"&":"&INDIRECT("設定!"&"G"&"9")&"4"))
=SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"C"&"8")&"13"&":"&INDIRECT("設定!"&"C"&"9")&"36")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"D"&"8")&"13"&":"&INDIRECT("設定!"&"D"&"9")&"36")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"E"&"8")&"13"&":"&INDIRECT("設定!"&"E"&"9")&"36")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"F"&"8")&"13"&":"&INDIRECT("設定!"&"F"&"9")&"36")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"G"&"8")&"13"&":"&INDIRECT("設定!"&"G"&"9")&"36"))
=SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"C"&"8")&"39"&":"&INDIRECT("設定!"&"C"&"9")&"67")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"D"&"8")&"39"&":"&INDIRECT("設定!"&"D"&"9")&"67")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"E"&"8")&"39"&":"&INDIRECT("設定!"&"E"&"9")&"67")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"F"&"8")&"39"&":"&INDIRECT("設定!"&"F"&"9")&"67")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"G"&"8")&"39"&":"&INDIRECT("設定!"&"G"&"9")&"67"))
=SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"C"&"8")&"9"&":"&INDIRECT("設定!"&"C"&"9")&"12"))+SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"C"&"8")&"68"&":"&INDIRECT("設定!"&"C"&"9")&"98")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"D"&"8")&"9"&":"&INDIRECT("設定!"&"D"&"9")&"12"))+SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"D"&"8")&"68"&":"&INDIRECT("設定!"&"D"&"9")&"98")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"E"&"8")&"9"&":"&INDIRECT("設定!"&"E"&"9")&"12"))+SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"E"&"8")&"68"&":"&INDIRECT("設定!"&"E"&"9")&"98")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"F"&"8")&"9"&":"&INDIRECT("設定!"&"F"&"9")&"12"))+SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"F"&"8")&"68"&":"&INDIRECT("設定!"&"F"&"9")&"98")) =SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"G"&"8")&"9"&":"&INDIRECT("設定!"&"G"&"9")&"12"))+SUM(INDIRECT($B$14&"!"&INDIRECT("設定!"&"G"&"8")&"68"&":"&INDIRECT("設定!"&"G"&"9")&"98"))
=SUM(D14:D16) =SUM(E14:E16) =SUM(F14:F16) =SUM(G14:G16) =SUM(H14:H16)
=SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"C"&"8")&"4"&":"&INDIRECT("設定!"&"C"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"D"&"8")&"4"&":"&INDIRECT("設定!"&"D"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"E"&"8")&"4"&":"&INDIRECT("設定!"&"E"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"F"&"8")&"4"&":"&INDIRECT("設定!"&"F"&"9")&"4")) =SUM(INDIRECT($B$9&"!"&INDIRECT("設定!"&"G"&"8")&"4"&":"&INDIRECT("設定!"&"G"&"9")&"4"))