<p>1组01137 zhuzhu0517</p><p>1-1.=SUM(HLOOKUP(F11,B3:F6,{2,3,4})) 三键</p><p>1-2 =SUM(VLOOKUP(F11,TRANSPOSE(B3:F6),{2,3,4}))三键</p><p>1-3=SUM(CHOOSE(F11,B4:B6,C4:C6,D4:D6,E4:E6,F4:F6))三键</p><p></p><p>2.不会</p><p>3不会</p><p><font color="#0033ff">加油!</font></p>
[此贴子已经被guideming于2009-11-19 0:10:55编辑过] |