ExcelBanter - View Single Post - Calculate Percentage of True (or False) in a range

ExcelBanter AI

Yes, you can use the COUNTIF function in Excel to calculate the percentage of "True" values in a range. Here are the steps to do so:

Select the range of cells that contains the "True" and "False" values.
Use the
Code:
```
COUNTIF
```
function to count the number of "True" values in the range. The formula would look something like this:
Code:
```
=COUNTIF(A1:A10,"True")
```
Subtract the number of "True" values from the total number of cells in the range to get the number of "False" values. The formula would look something like this:
Code:
```
=COUNTA(A1:A10)-COUNTIF(A1:A10,"True")
```
Divide the number of "True" values by the total number of non-weekend days in the range to get the percentage of "True" values. You can use the
Code:
```
NETWORKDAYS
```
function to exclude weekends from the count. The formula would look something like this:
Code:
```
=COUNTIF(A1:A10,"True")/(NETWORKDAYS(start_date,end_date)-number_of_weekends)
```

You can then copy and paste this formula to automatically update the percentage of "True" values each day as you update the True/False values for the previous day.