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

[µo°Ý] ½Ð°Ý¦³ÃöÀx¦s®æ¹Bºâ°ÝÃD

[µo°Ý] ½Ð°Ý¦³ÃöÀx¦s®æ¹Bºâ°ÝÃD

AÄ榳¤@°ï¼Æ¦r
¦bB1ªº¤½¦¡¥´ = SUM("A1:A" & C1)
¦bC1¥´¤W¼Æ¦r´N¥i¥H¨M©wAÄ榳¦h¤Ö­Ó¼Æ¦r¥[Á`
½Ð°Ý§Úªº¤½¦¡­n«ç»ò§ï¤~¯à¥Î¡AÁÂÁÂ

=SUM(INDIRECT("A1:A"&C1))
½Ð°Ñ¦Ò

TOP

¦^´_ 2# rakefrank


    ÁÂÁ¡A²Ä¤@¦¸¾Ç¨ì¥ÎINDIECT³o­Ó¨ç¼Æ¡AÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-12 12:30 ½s¿è

¦^´_ 1# Brandy
1¡B©w¸q¦WºÙ¡uData¡v¡A°Ñ·Ó¨ì¿é¤J =OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A)) ¡C
2¡B¥HÀx¦s®æC1ªº¼Æ¦r¨M©wAÄ榳¦h¤Ö­Ó¼Æ¦r¥[Á`¡A¬GÀx¦s®æB1¿é¤J
=SUMPRODUCT((Data=$C$1)*1)
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 4# p212

ÁÂÁ±zªº¦^ÂСA§Ú·Ó§Aªº¤èªk°µ¤F¤@­ÓÀɮסAµ²ªG¦n¹³¦³°ÝÃD¡A½Ð«ü±Ð¡AÁÂÁÂ
    test0612.rar (5.75 KB)

TOP

B1=SUMPRODUCT((Data)*1)
DATA=OFFSET(Sheet1!$A$1,,,C1)
½Ð°Ñ¦Ò

TOP

¦^´_ 6# rakefrank


    ·PÁ´£¨Ñ¤£¦Pªº¸Ñªk¡AÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-6-13 09:13 ½s¿è

¦^´_ 5# Brandy
¨Ì1#­ì°ÝÀ³没¿ù¡A°Ñ¨£¹Ï¡C
­Y¬O­n¥HÀx¦s®æC1ªº¼Æ¦r¨M©w¦bAÄ椤»PÀx¦s®æC1¬Û¦P¼Æ­ÈªÌ¥[Á`¡A«hÀx¦s®æB1¤½¦¡½Ð­×§ï¬°=SUMIF(Data,$C$1)¡C
½Ð°Ñ¦Ò¡I

fig.JPG (33.76 KB)

fig.JPG

TOP

¦^´_ 8# p212


    ÁÂÁ¤À¨É

TOP

§Ú·Q½Ð°Ý¤@¤U¤@¯ë¤½¦¡¤ºªºÀx¦s®æ½d³ò­n¦Û°ÊÅܤƬO¥Îoffset ¥h½Õ¾ã¶Ü

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD