Forum Discussion

ZachStone9's avatar
ZachStone9
Copper Contributor
Mar 18, 2019

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:   =...
COUNTIFS function
excel
formula
Pvberg's avatar
Pvberg
Copper Contributor
Mar 19, 2019

ZachStone9 

 

I suggest the simplest is probably to set up a helper column. It has the advantage of giving you the number you are looking for while at the same time identify the properties that meet your criteria.

There are a couple ways I could suggest:

  1. Add a column (D) that has the formula IF(B2/C2<=0.5,1,0) in the row D2 (with LU values in starting in B2 and V alues starting in C2, then in D1: =SUM(D2:D20) (this assumes 20 pairs of values).
  2. Alternative add the column (E) with with the formula =B2/C2 and copy it down until row 20 or to the end. in E1 put the formula =COUNTIF(E2:E20,"<.5").

Then you can use conditional formating to highlight all the rows that are less than .5

Resources