Forum Discussion
Impossible formula? Possibly COUNTIF Function
Hello, I want to create a COUNTIF formula that shows me how many Land Use Designations (LUDs) have building values less than 50% of the total property value. It is basically something like: =...
I have conditioned myself to think in terms of lists or arrays and only on rare occasions do I need to break the problem down to individual cells. In order to evade implicit intersection that will generate single-cell formula I tend to define many data objects of interest using Named formulas, thus 'lowBV' (low value building) could refer to Boolean conditions
= ( LU < V/2 )
or, in order to replace TRUE by 1.
= IF( LU < V/2, 1 ).
This leads to the formula
= COUNT( lowBV )
Conditional formats are a little more trouble because they do not accept arrays as the basis for formatting. Using Dynamic Arrays I had to introduce a second cell-by-cell formula 'highlight?'
=(@LU < @V/2)