Categories
Data Forms

Rows and Columns, Part 2: Using Formulas to Tally Data

View the original post

<p class="author">By <a href="https://www.uxmatters.com/authors/archives/2017/04/michael_morgan.php">Michael A. Morgan</a></p>

<p>In “<a href="https://www.uxmatters.com/mt/archives/2021/06/rows-and-columns-part-1-jump-starting-analysis-using-spreadsheets.php" title="Rows and Columns, Part 1: Jump-starting Analysis Using Spreadsheets">Rows and Columns, Part 1: Jump-starting Analysis Using Spreadsheets</a>,” I revealed the magic of using filtering, drop-down menus, and checkboxes in analyzing your user-research projects. Now in Part 2, I’ll discuss how you can use formulas to make your analyses easier to understand. If you’re new to using spreadsheets, you might find formulas somewhat intimidating. Some of them tend not to be very intuitive.</p>
<p class="sub-p">In Part 2, I’ll continue using the fictional example that I used in Part 1, which focuses on the Vinyl Exchange, a digital marketplace for buying and selling music. <a href="https://www.uxmatters.com/mt/archives/2021/10/rows-and-columns-part-2-using-formulas-to-tally-data.php" class="read_more_link">Read More</a></p>