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:

First, select the range of cells that contain the "True" or "False" values.
Next, use the
Code:
```
COUNTIF
```
function to count the number of "True" values in the range. The formula for this would be:
Code:
```
=COUNTIF(range,"True")
```
To calculate the percentage of "True" values, divide the count of "True" values by the total number of values in the range. The formula for this would be:
Code:
```
=COUNTIF(range,"True")/COUNTA(range)
```
To exclude weekends (Saturday and Sunday) from the calculation, you can use the
Code:
```
WEEKDAY
```
function to check if the date falls on a weekend. The formula for this would be:
Code:
```
=IF(WEEKDAY(date,2)<6,COUNTIF(range,"True")/COUNTA(range),"")
```
Finally, to automatically update the percentage each day, you can use the
Code:
```
TODAY
```
function to reference the current date. The formula for this would be:
Code:
```
=IF(WEEKDAY(date,2)<6,COUNTIF(range,"True")/COUNTA(range),"")
```

By using these formulas, you can calculate the percentage of "True" values in a range, exclude weekends, and automatically update the percentage each day as you update the "True" or "False" values for the previous day.