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

if¶W¹L¦h­ÓÀ³¦p¦óÂk¯Ç

if¶W¹L¦h­ÓÀ³¦p¦óÂk¯Ç

½Ð±Ð¦U¦ì«e½ú ¦bÀx¦s®æ¤º
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7),if(fy7=4,sum(w7:ab7,k7:m7)if(fy7=5,sum(x7:ab7,k7:n7)
  if(fy7=6,sum(y7:ab7,k7:o7),xxx)&if(fy7=7,sum(z7:ab7,k7:p7),if(fy7=8,sum(aa7:ab7,k7:q7),if(fy7=9,sum(ab7,k7:r7),if(fy7=10,sum(k7:s7),yyy)
    xxx = À³¦p¦ó¶ñ¼g      yyy= À³¦p¦ó¶ñ¼g
©Î¬O¦³§ó¦n²[¼Æ¥i¥N´À½Ð½ç±Ð ÁÂÁÂ

¨Ï¥ÎCHOOSE¨ç¼Æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-9-9 00:11 ½s¿è
½Ð±Ð¦U¦ì«e½ú ¦bÀx¦s®æ¤º
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7), ...
jim µoªí©ó 2014-9-7 11:25

§Aªº¤½¦¡¥ª¥k¬A©·¼Æ¶q¤£¬Ûµ¥,
³o¼Ë¤£¯à½T©w¸Ó¦p¦ó§ï¤½¦¡.

TOP

¦^´_ 3# luhpro

½Ð±Ð¦U¦ì«e½ú ¦bÀx¦s®æ¤º
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7),if(fy7=4,sum(w7:ab7,k7:m7),if(fy7=5,sum(x7:ab7,k7:n7),
  if(fy7=6,sum(y7:ab7,k7:o7),xxx))))))&if(fy7=7,sum(z7:ab7,k7:p7),if(fy7=8,sum(aa7:ab7,k7:q7),if(fy7=9,sum(ab7,k7:r7),if(fy7=10,sum(k7:s7),yyy))))
    xxx = À³¦p¦ó¶ñ¼g      yyy= À³¦p¦ó¶ñ¼g
©Î¬O¦³§ó¦n²[¼Æ¥i¥N´À½Ð½ç±Ð ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD