title: Pragmatically Get Count of Pivot Table Data
body: <p>Suppose I have some sample data like so:</p>
  
  <p><a href="https://i.stack.imgur.com/iw0UK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iw0UK.png" alt="enter image description here"></a></p>
  
  <p>and I create a Pivot Table and order by Product > Sales Rep > Sales</p>
  
  <p><a href="https://i.stack.imgur.com/WDDJi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WDDJi.png" alt="enter image description here"></a></p>
  
  <p>If I want the # of sales <code>John</code> had for <code>Product1</code> I would do <code>=GETPIVOTDATA("Sales",$A$3,"Product","Product1","Sales Rep","John")</code></p>
  
  <p>But how would I get a count of the entries there are. i.e. for <code>Product1</code>, <code>John</code> had <code>4</code> and <code>Kevin</code> had <code>2</code></p>
  
  <p>Is it possible to get this count using <code>GETPIVOTDATA()</code>?</p>