Customer Forum
Count 0s and 1s
| Posted: 2023-07-26 17:40 |
|
Imagine you have an IF statement in your details view that displays a 0 or 1. For example, if the Person doesn't have an email address, display a 0 but if they do, display a 1. How would you count the 0s and 1s, given that Workbooks doesn't have a COUNTIF function? |
| Posted: Thu, 27.07.2023 - 11:14 |
|
The syntax (in the summary view) would be: SUM(IF( PARENT('Has Email?') = 1,1,0)) NB use SUM not COUNT! |
- Log in to post comments