topic COUNTIF in Developers Questions https://community.esri.com/t5/developers-questions/countif/m-p/54210#M290 <HTML><HEAD></HEAD><BODY><P>I'd like to use Arcade to perform a COUNTIF function on my data.&nbsp; For example, if I have the following data, the COUNTIF would return the following count</P><P></P><P>Type &nbsp; &nbsp; &nbsp; &nbsp; COUNTIF</P><P>Apple &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2</P><P>Apple &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2</P><P>Orange &nbsp; &nbsp; &nbsp; 1</P><P>Banana &nbsp; &nbsp; &nbsp; 1</P><P></P><P>Importantly, I'd like the count to adjust if the records are filtered.&nbsp; So in the above example if the second Apple record is filtered out, the count for Apple would revert to 1.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 01 Aug 2017 15:46:44 GMT AlexTripp1 2017-08-01T15:46:44Z COUNTIF https://community.esri.com/t5/developers-questions/countif/m-p/54210#M290 <HTML><HEAD></HEAD><BODY><P>I'd like to use Arcade to perform a COUNTIF function on my data.&nbsp; For example, if I have the following data, the COUNTIF would return the following count</P><P></P><P>Type &nbsp; &nbsp; &nbsp; &nbsp; COUNTIF</P><P>Apple &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2</P><P>Apple &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2</P><P>Orange &nbsp; &nbsp; &nbsp; 1</P><P>Banana &nbsp; &nbsp; &nbsp; 1</P><P></P><P>Importantly, I'd like the count to adjust if the records are filtered.&nbsp; So in the above example if the second Apple record is filtered out, the count for Apple would revert to 1.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 01 Aug 2017 15:46:44 GMT https://community.esri.com/t5/developers-questions/countif/m-p/54210#M290 AlexTripp1 2017-08-01T15:46:44Z