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

[µo°Ý] ·Q§@Ãþ¦ü¼Ï¯Ã¤ÀªRªºªí®æ¡A¨ç¼Æ­n«ç»ò¼g©O?

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-3-31 22:13 ½s¿è

¦^´_ 9# §±æ¢


   > ¥ÎSUMIF¨ç¼Æ¡A¨S¿ìªk¹ï·Ó¤ë¥÷¡A­n«ç»ò¼g¨ç¼Æ¤~¥i¥H¦b¿é¤J¤ë¥÷¤§«á¡A·|±N¤u§@¤H­û¦b¬Y­Ó¤ëªº¤u§@¤Ñ¼ÆÅã¥Ü¥X¨Ó©O?

¤èªk¤@  ­n¨Ï¥Î2­Ó¤é´Á¿z¿ï
SUMIF(.....,¤é´Á, ">=" &  DATE(¦~,¤ë,1), ¤é´Á,  "<=" & DATE(¦~,¤ë+1,0))     

SUMIFS(ÂI¤u²M³æ!$F:$F,
  ÂI¤u²M³æ!$B:$B,©m¦W,
  ÂI¤u²M³æ!$A:$A,">="&DATE(¦~+1911,¤ë,1),
  ÂI¤u²M³æ!$A:$A,"<="&DATE(¦~+1911,¤ë+1,0)
)

¤èªk¤G ¦b¸ê®Æ¦ì¸m¼W¥[»²§UÄæ  ¦~¤ë(yyyymm)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 10# ML089


    ¨S·Q¨ì¥i¥Hª½±µ±q¨º¸Ì§ì¨ú¡A·P®¦©O!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD