CHALLENGE 🔥 - SUMIF Function in Looker Studio | Calculate SUM based on Multiple Conditions / Rules

How to use SUM + IF formula in Looker Studio? (a.k.a. Google Data Studio). In this video, we cover 4 EXAMPLES to help you understand how to translate your business rules into formulas.

I decided to make today's video more interesting, by incorporating a popular Data Science dataset. I'll come out with 4 questions (quiz) that you could answer using the dataset. I hope it makes your GDS learning easy and fun!

✨BEST EXERCISE FOR YOU✨
4 SUMIF examples & tutorial are included, so you'll learn to write the sum + if function, from simple ones to the PRO level using a mix of multiple operators:
1) Logical operators (AND, OR)
2) Comparison operators (i.e. greater than, equal to, greater than or equal to, lesser than...)

✨Challenge yourself! ✨
For each question, pause the video and find the answer, then come back to this video again to check your answer! 🔥 Let me know if you got all the questions right!

📒 ADDITIONAL RESOURCES

⭐️ NEW TO GOOGLE DATA STUDIO
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨

F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!

[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?

👉 Shop Danalyser Templates Collection

#GoogleDataStudio #Danalyser

--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------

💌 W A T C H N E X T
⚈ Show current date in dashboard

⚈ Export Data from Data Studio

⚈ Automation in Data Studio (Email Delivery)

Keywords:
SUMIF with multiple criteria, SUMIF Google Looker Studio, Data Studio SumIf with Examples, Case SUM function, Calculated Field for Sum If, Without Error, SUMIFS in Looker Studio, Google Looker Studio Calculated Field Tutorials, Looker Studio Function Tutorials, How to Use Logical Operators in Looker Studio, How to use Comparison Operators in Looker Studio.

[danalyser]

Do you enjoy the challenge? Comment below if you like more of these kind of videos to be Looker Studio PRO! 🔥

[sivakumarak]

This is very useful! Is there a way to have the Total value is fixed even if apply filters?

[NestorLuis-ov]

Gracias por la explicación y la buena practica de enseñar.

[ashokkpoonia]

You're the best. Solved the issue that was bugging me.

[Iamgroot]

I missed you much!. nice to see you back!

[juliautomo]

thank you!!

if we only pun if(...) formula but created from the metrics section of calculated field. will it yield the same result? what is the difference between that and putting sum(if(...))?

[travistai-]

Yes! Thank you for this! Helped me with an issue I was facing as well :)

[jyrenekleinflores]

I remember the titanic challenge in kaggle.... Great video

[jordi]

Very helpful video, thanks!!! Great work

[catncurious]

THANKS!!! I've had way too many filters in my dashboard.🥴 This helps a lot. ✨

[rubengallardoreynafarje]

Gracias!!! Cómo puedo hacer para contar las veces que aparecen valores únicos en celdas de columnas que tienen datos separados por comas

[LevelUp_No]

hi, nicse to see you and thank you so much for your VDO. Please help me to solve this case. how to freeze 1 axis data in look studio. i mean that, if in the data file does not have data but in the looker still show on chart?

[jeromvert]

Can we add and substract within the dimension values. For eg I want to calculate the difference between Sex Male 50 and Female 30, And Difference would be 20. Is there any formula for that.

[khaledothman]

Great work Dana Thank You
That helped a lot
I wonder if you have a LinkedIn Profile ?

[Leocrgr]

Good day, I wanted to see if you can help me with this particular formula, I can't find a way to replicate it in Looker


=COUNTIFSET(Column1, "="&Criteria, Column2, "<>"&Criteria2)

I wanted to know if there is a way to replicate this function, thank you

[dmbperformance]

Great but in case you have male named differently for example males, male, MALE ....etc how would you do it?

[LakshyaSharma-jb]

MINIF function, can we do this as well

[achmadriandi]

Kak kalau mau buat formula contains bisa gak?

[nl]

just wanna ask right do u give class? 我也是kl 人