すぐマク  Home      この画面を閉じるには、×ボタンをクリック

セル セル セル
B5=IF($A5="","",SUM(判別!$C3:$AG3)) C5=IF($A5="","",SUM(判別!$D2:$AH2)) D5=IF(A5="","",B5-C5)
B6=IF($A6="","",SUM(判別!$C5:$AG5)) C6=IF($A6="","",SUM(判別!$D4:$AH4)) D6=IF(A6="","",B6-C6)
B7=IF($A7="","",SUM(判別!$C7:$AG7)) C7=IF($A7="","",SUM(判別!$D6:$AH6)) D7=IF(A7="","",B7-C7)
B8=IF($A8="","",SUM(判別!$C9:$AG9)) C8=IF($A8="","",SUM(判別!$D8:$AH8)) D8=IF(A8="","",B8-C8)
B9=IF($A9="","",SUM(判別!$C11:$AG11)) C9=IF($A9="","",SUM(判別!$D10:$AH10)) D9=IF(A9="","",B9-C9)
B10=IF($A10="","",SUM(判別!$C13:$AG13)) C10=IF($A10="","",SUM(判別!$D12:$AH12)) D10=IF(A10="","",B10-C10)
B11=IF($A11="","",SUM(判別!$C15:$AG15)) C11=IF($A11="","",SUM(判別!$D14:$AH14)) D11=IF(A11="","",B11-C11)
B12=IF($A12="","",SUM(判別!$C17:$AG17)) C12=IF($A12="","",SUM(判別!$D16:$AH16)) D12=IF(A12="","",B12-C12)
B13=IF($A13="","",SUM(判別!$C19:$AG19)) C13=IF($A13="","",SUM(判別!$D18:$AH18)) D13=IF(A13="","",B13-C13)
B14=IF($A14="","",SUM(判別!$C21:$AG21)) C14=IF($A14="","",SUM(判別!$D20:$AH20)) D14=IF(A14="","",B14-C14)
B15=IF($A15="","",SUM(判別!$C23:$AG23)) C15=IF($A15="","",SUM(判別!$D22:$AH22)) D15=IF(A15="","",B15-C15)
B16=IF($A16="","",SUM(判別!$C25:$AG25)) C16=IF($A16="","",SUM(判別!$D24:$AH24)) D16=IF(A16="","",B16-C16)
B17=IF($A17="","",SUM(判別!$C27:$AG27)) C17=IF($A17="","",SUM(判別!$D26:$AH26)) D17=IF(A17="","",B17-C17)
B18=SUM(B5:B17) C18=SUM(C5:C17) D18=SUM(D5:D17)