title: Business Objects CountIf by cell reference
body: <p>So I have a column with this data</p>
  
  <pre><code>1
  1
  1
  2
  3
  4
  5
  5
  5
  </code></pre>
  
  <p>how can I do a count if where the value at any given location in the above table is equal to a cell i select? i.e. doing <code>Count([NUMBER]) Where([NUMBER] = Coordinates(0,0))</code> would return 3, because there are 3 rows where the value is one in the 0 position.</p>
  
  <p>it's basically like in excel where you can do <code>COUNTIF(A:A, 1)</code> and it would give you the total number of rows where the value in <code>A:A</code> is 1. is this possible to do in business objects web intelligence? </p>