=COUNTIF(B2:B30, "Apple")

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

请您先登陆,再发跟帖!