In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
In this video, we'll look at how to plot results from a survey question in an Excel bar chart.
Here we have data from a survey we ran recently. We've got around 3900 responses to the question "What version of Excel do you use most?".
Let's plot the data in a chart.
The first step is to build a summary table.
First, I'll convert the data to an Excel table. This step is not required, but it will make the formulas easier to write.
For the first formula, I need to count all responses. Since we have a table, I can use the ROWS function with the table name.
Now, to count the responses already in column E, we'll use COUNTIF function.
Range is the Response column in the table, and we get criteria from column E
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3...
When working with data, a common need is to perform summary calculations that show total counts in different ways. For example, total counts by category, color, size, status, etc. The COUNTIF function is a good way to generate these kinds of totals...
COUNTIF is a function to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. The COUNTIF function supports logical operators (>,...