[µo°Ý] ½Ð°Ý³o¤@¬q¤½¦¡¥i¥H²¤Æ¶Ü¡H

¬PªÅÉ@¦ÐÁl

½Ð°Ý¥H¤U¤½¦¡¥i¥H²¤Æ¶Ü?

=INDEX($C$2:$D$9,MATCH("R1",$A$2:$A$9,0),MATCH($I$1,$C$1:$D$1,0))+INDEX($C$2:$D$9,MATCH("R2",$A$2:$A$9,0),MATCH($I$1,$C$1:$D$1,0))+INDEX($C$2:$D$9,MATCH("R3",$A$2:$A$9,0),MATCH($I$1,$C$1:$D$1,0))

³Â·Ð¦U¦ì¤j¤j¤F¡AÁÂÁ !

¬PªÅÉ@¦ÐÁl

¦^´_ 1# ¬PªÅÉ@¦ÐÁl

¥H¤U¬°«á¾Ç¦Û¦æ²¤Æªº
=SUM(INDEX($C$2:$D$9,MATCH({"R1","R2","R3"},$A$2:$A$9,0),MATCH($I$1,$C$1:$D$1,0)))

¤£ª¾¬O§_¦U¦ì¤j¤j¦³§ó¦nªº¼gªk©O?

hcm19522

I5{=SUM(IFERROR(VLOOKUP(T(IF({1},F2:F9)),A:D,3+(I1=D1),),))
¥DÁä¥i­«½Æ=SUMPRODUCT(COUNTIF(F:F,A2:A9)*OFFSET(C2:C9,,D1=I1))

¬PªÅÉ@¦ÐÁl

¦^´_ 3# hcm19522
·PÁ«e½úªº¦^ÂÐ
½Ð°Ý¥i¥Hªþ¤W»¡©ú¶Ü?

ML089

=SUM(SUMIF(A:A,"R"&{1,2,3},OFFSET(C:C,,N(I1=D1),)))
»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

ML089

=SUM(LOOKUP("R"&{1,2,3},A:A,OFFSET(C:C,,N(I1=D1))))
³o¤½¦¡¤]¥i¥H

¬PªÅÉ@¦ÐÁl

¦^´_ 6# ML089

·PÁ¤j¤j¸Ñ»¡¤Î±Ð¾Ç
«á¾Ç¨ü±Ð¤F
ªGµM¤½¦¡¥i¥H«Ü¦hÅÜ
¥þ¬Ý«ç»òÀ³¥Î
·PÁ«e½ú±Ð¾Ç¡I

­ã´£³¡ªL

=SUMPRODUCT(SUMIF(A:A,F2:F9,OFFSET(C:C,,MATCH(I1,C1:E1,)-1)))