New answers tagged data-validation
For a slightly different approach you could use AVERAGE, i.e. this "array formula" =AVERAGE(IF('LP - All Properties'!G:G=C2:D2,IF('LP - All Properties'!L:L="Leased",1,0))) confirmed with CTRL+SHIFT+ENTER This only works when C2:D2 is a horizontal vector
The parameter C2:D2 forms an array and thus you need to make it an array function. The correct formula would be =(SUM(COUNTIFS('LP - All Properties'!G:G,C2:D2,'LP - All Properties'!L:L,"Leased")))/SUM(COUNTIF('LP - All Properties'!G:G,C2:D2)) And then here comes to the tricky part - instead of hitting Enter finishing your input, you will need to press ...
Top 50 recent answers are included