ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

½Ð°Ý¥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ÁÂÁ !

¦^´_ 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?

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2023-6-8 11:50 ½s¿è

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))

11431.png (8.25 KB)

11431.png

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

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

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2023-6-8 18:23 ½s¿è

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

TOP

=SUM(LOOKUP("R"&{1,2,3},A:A,OFFSET(C:C,,N(I1=D1))))
³o¤½¦¡¤]¥i¥H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD