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

½Ð°Ý

½Ð°Ý

§Ú·Q¦bB6Åã¥Ü: ¦pªGB1¦ÜE1¤º¦³1ªº¸Ü, B3´N·|¥[E3, §Yµ¥©ó7
½Ð°ÝÀ³¸Ó«ç¼Ë...

¦^´_ 1# nankai


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

SUMIF(B1:E1,A6,B3:E3)

TOP

¨ÌÃD·N¦n¹³¬O³o¼Ë,¦ý§Úª¾¹D³o¼Ë¬O¿ùªº,¦]¬°b7µª®×¬O5
=if(countif(b1:e1,1),b3+e3,0)
©Ò¥H°Ý°ÝÃD­n§âÃD·N»¡²M·¡

¥Îsumif()¬O¤£¿ùªº¥Îªk
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 3# nankai

¹Ï¤ùÀ³¸Ó©Ò¦³ÂsÄýªÌ³£¯à¬Ý¨ì
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD