開始使用免費開始

COUNTIF practice

You're in charge of planning a conference and this is the starting point for your mailing list.

Mailing invitations is expensive so you want to be sure there are no duplicate entries.

Before we dive into the conditional formatting, we'll start off with a little practice of the COUNTIF function.

After a little bit of work, you'll understand how the function works.

本練習屬於課程

Google 試算表的條件格式

檢視課程

練習說明

  • Using the COUNTIF function, write a function in cell G3 that counts the amount of times the value in A3 occurs in column A.

  • Copy your function into all of the cells in the range G3 to G18.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習