Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Tally in Excel
A tally is just a count of how often each value appears. Excel handles tallies with `COUNTIF` for one value, `COUNTA` for non-blank totals, and pivot tables for grouped tallies.
Tally one specific value with COUNTIF
In any empty cell, type:
=COUNTIF(A2:A100, "Yes")
This counts how many times Yes appears in A2:A100. Replace the literal with a cell reference (=COUNTIF(A2:A100, C1)) to tally whatever value you put in C1.
Tally each unique value at once
- List the unique values you want to count in column C.
- In D2, enter
=COUNTIF($A$2:$A$100, C2). - Drag the formula down—you''ll get a per-value tally next to each label.
Use a pivot table for fast group tallies
- Click anywhere in your data and choose Insert → PivotTable.
- Drag the column you want to tally into both Rows and Values.
- The Values field defaults to Count, giving you a tally for every unique entry.
Count non-blanks with COUNTA
=COUNTA(A2:A100) returns the number of non-empty cells, useful when you only need a total of responses.
Try it faster with guidance
Skip the formula juggling—let Vocordia guide you through it with voice and on-screen cursor guidance so you can pick the right tally method without second-guessing.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.