2005-03-28 09:15:34酷仔♫° 瘋 

函數

[黑色]0 "公斤";[紅色]"減" 0 "公斤";[藍色]"完美身材"

=SUMIF(E7:E16,"女",F7:F16)/COUNTIF(E7:E16,"女")

=IF(G7>=170,"高各兒",IF(G7<=155,"小不點","一般"))