=COUNTIF(B2:B30, "Apple")

Under AppTotal, enter the function. B2:B30 is the range. Use the same way for Orange .....

請您先登陸,再發跟帖!