About Us

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate true/false value based on array text input	Christian[_2_]	Excel Worksheet Functions	3	March 21st 07 09:28 PM
Hiding rows in a range based on TRUE/FALSE value in each row	michaelberrier	Excel Discussion (Misc queries)	1	December 28th 06 10:33 PM
Return True/False to check duplicate items in a range with one for	Tetsuya Oguma	Excel Worksheet Functions	10	October 21st 06 03:20 AM
Function to return True/False if all are validated as True by ISNU	Tetsuya Oguma	Excel Worksheet Functions	2	March 15th 06 10:28 AM
Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE	IFfunction	Excel Discussion (Misc queries)	2	October 10th 05 10:34 AM

Menu

About Us