| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Percentage of True (or False) in a range
Hi, I have a column of values, either "true" or "false".
The rows are current dates. I want to calculate the % of "True" from a specified row (prior date) to "Yesterdays" date. (Saturday & Sundays are excluded!) Can I use one of the standard functions to automatically calculate the % "true", automatically updated each day, as I update the True/False for the previous day? Any pointers would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate true/false value based on array text input | Excel Worksheet Functions | |||
| Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
| Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE | Excel Discussion (Misc queries) | |||
Threaded Mode
