AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.5K members online now
1.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

CountIf Formula?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

What is it?

 

Count if column equals "Apple"

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Tony T
May 2017

CountIf Formula?

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

SUM(CASE WHEN REGEXP_MATCH(Column, '^Apple.*') THEN 1 ELSE 0 END)

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Tony T
May 2017

CountIf Formula?

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

SUM(CASE WHEN REGEXP_MATCH(Column, '^Apple.*') THEN 1 ELSE 0 END)

 

CountIf Formula?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks much

CountIf Formula?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

SUM(CASE WHEN <column> = "Apple"  THEN 1 ELSE 0 END )

CountIf Formula?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi, Can we able to do multiple case statements. Like Orange, Berry?