I-Circle Forum

我相信好易...不過我係唔識，冇辦法！

c) Cells I4 to I8 store the number of students whose 'updated GPA 's are within certain ranges.
Enter a formula for each cell(four formulas are required).

thanks a lot!!

多謝樓主俾機會我溫習電腦

I4: =COUNTIF(E4:E13,">=3.5")
I5: =COUNTIF(E4:E13,">=3")-I4
I6: =COUNTIF(E4:E13,">=2")-I4-I5
I7: =COUNTIF(E4:E13,">=1")-I4-I5-I6
I8: =COUNTIF(E4:E13,">=0")-I4-I5-I6-I7 OR =COUNT(E4:E13)-I4-I5-I6-I7

呢個仲可以玩埋FREQUENCY,不過要改H3到H8既內容

份附件就包左用COUNTIF同FREQUENCY,自己去研究下

多謝晒！

thx..............