Excel's COUNTIF and COUNTA functions can be combined to find the percentage of a specific value in a range of data. This value can be text, numbers, Boolean values, or any other type of data.

In the example below, the two functions are combined to calculate the percentage of Yes/No responses in a range of data.

The formula used for this is:

In the example, the COUNTIF function counts the number of times the desired data (the answer Yes) is found in the selected group of cells.