Count percentage of specific text in a range of cells
I am trying to figure out how get the percentage of times a specific text
occurs in a spreadsheet. |
Count percentage of specific text in a range of cells
You can get the number of times it occurs by using COUNTIF function
For example to count how many times Test occurs in Col C use =COUNTIF(C:C,"Test") You can then calculate the percentage as you want. "kruggie2000" wrote: I am trying to figure out how get the percentage of times a specific text occurs in a spreadsheet. |
All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com