2005-03-28 09:15:34酷仔♫° 瘋
函數
[黑色]0 "公斤";[紅色]"減" 0 "公斤";[藍色]"完美身材"
=SUMIF(E7:E16,"女",F7:F16)/COUNTIF(E7:E16,"女")
=IF(G7>=170,"高各兒",IF(G7<=155,"小不點","一般"))
=SUMIF(E7:E16,"女",F7:F16)/COUNTIF(E7:E16,"女")
=IF(G7>=170,"高各兒",IF(G7<=155,"小不點","一般"))