Calculator
Example Data Table
| Data Set | Criteria | Matched Count | Total Count | Percentage |
|---|---|---|---|---|
| Complete, Pending, Complete, Delayed, Complete | =Complete | 3 | 5 | 60% |
| 92, 75, 88, 61, 95 | >80 | 3 | 5 | 60% |
| Paid, Unpaid, Paid, Pending, Paid | *paid* | 3 | 5 | 60% |
Formula Used
COUNTIF Percentage = COUNTIF matched values ÷ total considered values × 100
The matched count is the number of values that meet the selected criterion. The total considered value is the denominator. When blank values are excluded, only non-blank values are counted.
Spreadsheet style: =COUNTIF(range, criteria) / COUNTA(range) * 100
How to Use This Calculator
- Paste your values into the data box.
- Select the delimiter that matches your pasted list.
- Enter a criterion, such as =Complete or >50.
- Choose trimming, blank, and case options.
- Press the calculate button to view the result.
- Use CSV or PDF export for reporting.
Why COUNTIF Percentages Matter
A COUNTIF percentage turns a simple count into a useful rate. It shows how much of a list meets one rule. The rule may be a word, a number, a blank value, or a wildcard pattern. This helps you compare groups without opening a spreadsheet. You can paste values, set a criterion, and read the matched share instantly.
Practical Uses
This calculator is useful for audits, sales reviews, attendance checks, survey summaries, and quality control. A manager can measure how many orders are delayed. A teacher can check how many scores pass a target. A support team can count tickets with a certain status. The final percentage makes the result easier to explain.
Better Than Manual Counting
Manual counting is slow and easy to misread. It also becomes harder when data contains spaces, mixed case, empty cells, or many rows. This tool reduces that risk. It trims values when needed. It can match text with or without case sensitivity. It also supports comparison signs like greater than, less than, and not equal.
How Results Help Decisions
A percentage is clearer than a raw count. Ten matching rows may be high in a list of twelve. The same ten rows may be low in a list of two hundred. The calculator shows total values, matched values, unmatched values, and the final rate. These details give useful context.
Clean Export Options
Reports often need proof. Use the export buttons to save the summary as a CSV file or a PDF file. The CSV file works well for spreadsheets. The PDF file is useful for sharing a simple record with clients, teams, or supervisors. Both options keep the main inputs and results together.
Data Entry Tips
Paste one item per line for the best control. You can also use commas, tabs, pipes, or semicolons. Choose auto detection when the list is mixed. Check the blank setting before calculating. This keeps the denominator correct. Then review the example table to confirm the expected logic before using live data. Use labels for exported files. Store them with project notes, so future reviews can trace each percentage back to its source data.
FAQs
What does this calculator do?
It counts values that match your criterion. Then it divides that count by the total considered values. The result is shown as a percentage.
Can I use number criteria?
Yes. You can enter criteria like >80, <100, >=50, or <>0. The calculator compares numeric values when both sides are numbers.
Can I match text values?
Yes. Use exact text, such as =Complete. You can also use wildcard patterns like *paid* to match values containing that word.
How are blank values handled?
Blank values are excluded by default. Enable the blank option when blanks should be included in the total denominator or matched by blank criteria.
Is text matching case-sensitive?
Case-sensitive matching is optional. Leave it off when Complete and complete should match. Turn it on when letter case must be exact.
What formula is used?
The formula is matched count divided by total considered count, multiplied by 100. It works like COUNTIF divided by COUNTA in spreadsheets.
Can I export the result?
Yes. Use the CSV button for spreadsheet review. Use the PDF button when you need a simple printable report.
Which delimiter should I choose?
Choose line by line for pasted lists. Choose comma, semicolon, tab, or pipe for separated data. Auto detect works well for mixed simple lists.