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

²Å¦X±ø¥ó²Î­p³æÄæ­Ó¼Æ

²Å¦X±ø¥ó²Î­p³æÄæ­Ó¼Æ

½Ð°Ý¦U¦ì¤j¤j
²Å¦X±ø¥ó¦WºÙ²Î­p³æÄæ­Ó¼Æ¨ç¼Æ³]©w
¦p¦ó¶ñ¼g
ÁÂÁÂ
¦pªþ¥ó:)
ÀÉ®× Book1.rar (2.46 KB)

¦^´_ 1# ÅQ®ð¨«¥þ¨­


D2Àx¦s®æ
=SUMPRODUCT(($D$7:$K$7=D2)*($D$8:$K$30>0))

TOP

«Øij¨Ï¥Î<>""
=SUMPRODUCT(($D$7:$I$7=D2)*($D$8:$I$30<>""))
¥t´£¨Ñ°Ñ¦Ò
=COUNTA(OFFSET($C$7,1,MATCH($D$2,$D$7:$I$7,0),23,))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¯u¬O¦n¤èªk¡AÁÂÁ¤À¨É¤F¡C

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD