COUNTIF function & Column charts in Google Sheets: Lesson + Data project

Key Takeaways

in this video I'm going to show you how to use the count if function as well as how to create a column chart based off of the data that we generate with the ctif function and if you want to follow along with me I've included the raw data in the description as well as a video on how to import data into your spreadsheet if you don't know how to do that yet so here we have our raw data which is a list of task IDs and the people that the tasks were assigned two and we want to find how many tasks were assigned to each person and so what we want to do is count how many times each name appears in our data so the first thing that we need is a list of names and how we can do this really quickly is by using the unique function which removes duplicates so I'm going to type equals unique parentheses and then I'm going to specify the range B2 through b I'm looking through the range B2 through b and telling Google Sheets to remove the duplicates from this range which in this case automatically generates a list that gives us one of each different name so now that we have our list of names we can use the count if function like this equals count if parenthesis and now we're going to specif spey the range that we're looking through when we're counting and so this is going to be column B we're looking through column B now type a comma and now I'm going to specify cell D2 so I'm telling Google Sheets count how many times the text that is in cell D2 is found in column B now I'm going to press enter and our coun IF function is telling us that the word Alice was found 22 times in column B and so now I'm going to copy this formula down the column so that it calculates the count for each of the different names and so I'm going to copy cell E2 and then I'm going to paste it into the rows below and Google Sheets has automatically adjusted our formulas so that in each row we're counting how many times each name appeared in column B all right so the data on the left was not suitable for a column chart but now that we've summarized the data with the count if function it's ready for us to add a column chart and so this is very easy I'm going to select cell D1 through cell E6 I'm going to click insert on the top toolbar and then click chart and Google Sheets has automatically inserted a column chart for us now if you want you can select a different type of chart in the chart editor under the setup tab under chart type and also if you want you can customize the chart whatever way that you want so if you want to learn more about creating charts I've linked a video below where you can learn to create a variety of charts as well as how to customize them in detail and if you want to learn how to build dashboards in Google Sheets check out my full dashboards and data analysis course that I've Linked In the description I hope you like the video if you did please like And subscribe and have a great day