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

[µo°Ý] ¤£ª¾­n¨Ï¥Î¦óºØ¨ç¼Æ

J1
=SUMIF(Sheet2!F:V,F1,Sheet2!G$1)

H3

{=INDIRECT("Sheet2!"&ADDRESS(MAX((F1=Sheet2!F2:V3)*ROW(F2:V3)),MAX((F1=Sheet2!F2:V3)*COLUMN(F2:V3)-2),4))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD