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

[µo°Ý] ½Ð±Ð¦h¼Æªí®æ¿z¿ï¥[Á`ªº¼gªk­×¥¿°ÝÃD?

[µo°Ý] ½Ð±Ð¦h¼Æªí®æ¿z¿ï¥[Á`ªº¼gªk­×¥¿°ÝÃD?

½Ð°Ý¦U¦ì
¦]¬°³Ìªñ¦³¼g¤F¤@­ÓÀÉ®×

=SUMIF('T-1'!I9:I218,"ªù¥«*",'T-1'!G9:G218)

¸Ì­±¦³T-1¤u§@ªí¦ÜT-12¤u§@ªí
¦@12±i¤u§@ªí

·Q½Ð³o­Ó­n«ç»ò­×§ï§Ë¤ñ¸û¦n©O? ÁÂÁÂ

=SUMIF('T-1:T-12'!I9:I218,"ªù¥«*",'T-1:T-12'!G9:G218)

§Ú§ï¦¨³o¼ËEXCEL·|§PÂ_¿ù»~...

¦^´_ 3# ­ã´£³¡ªL

·PÁÂ
³oºØ¼gªk¤ñ­ì¥»T-1 .... + T12ÁYµu«Ü¦h¤ñ¸û®e©ö¬Ý±o²M·¡

TOP

=SUMPRODUCT(SUMIF(INDIRECT("'T-"&ROW($1:$12)&"'!I9:I218"),"ªù¥«*",INDIRECT("'T-"&ROW($1:$12)&"'!G9:G218")))

TOP

SUMIF('T-1'!I9:I218,"ªù¥«*",'T-1'!G9:G218)+SUMIF('T-2'!I9:I218,"ªù¥«*",'T-2'!G9:G218)+....+SUMIF('T-12'!I9:I218,"ªù¥«*",'T-12'!G9:G218)
ù

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD