Hey everyone, In this video, I want to show you how you can sum values in Google Sheets based on conditions. Example : Color | Value Red | 210 Green | 18 Red | 36 Yellow | 14 Blue | 10 Red | 27 How can you sum the values of Red colors only ? I am sharing with you 3 ways to do it (SUMIF, Pivot Tables, QUERY) Enjoy the video. See you around, Mohamed.

In this video, I am sharing with you all the secrets of creating an effective Entry Sheet in Google Sheets. We will work on a Sales Entry Sheet where users effectively populate business sales. In this video, you will learn how to use Data Validation in Google Sheets to create Dropdown menus. I will also share with you a special function that you can use to automatically populate data in your columns. I am 💯% sure you will looooooove it ! See you around.