시작하기무료로 시작하기

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 Sheets에서 조건부 서식

강의 보기

연습 안내

  • 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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작