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

[µo°Ý] ·Q´îµu¤½¦¡

[µo°Ý] ·Q´îµu¤½¦¡

=IFERROR(VLOOKUP($P2,a_¤j¼Ó¸ê®Æ,5,FALSE),0)+IFERROR(VLOOKUP($P3,a_¤j¼Ó¸ê®Æ,5,FALSE),0)+IFERROR(VLOOKUP($P4,a_¤j¼Ó¸ê®Æ,5,FALSE),0)+IFERROR(VLOOKUP($P5,a_¤j¼Ó¸ê®Æ,5,FALSE),0)
·Q´îµu¤½¦¡
=IFERROR(VLOOKUP($P2,a_¤j¼Ó¸ê®Æ,5,FALSE)+VLOOKUP($P3,a_¤j¼Ó¸ê®Æ,5,FALSE)+VLOOKUP($P4,a_¤j¼Ó¸ê®Æ,5,FALSE)+VLOOKUP($P5,a_¤j¼Ó¸ê®Æ,5,FALSE),0)
¦ý³o¼Ë¥u­n¨ä¤¤¦³¤@­Ó§ä¤£¨ì¸ê®Æ´N¤£Åã¥Ü­È

½Ð°Ý¤j¤jªù¦³¨S¦³¦nªº¤èªk©O?
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD