title: Excel - Calculated Field COUNT function
body: <p>Why does the calculated field (Count(Age)) evaluate to 1 (For row Mark below) when it should evaluate to 3? I have been searching around the internet &amp; people say that 'Calculated Fields always SUM 1st &amp; then perform the calculation' so is this essentially:</p>
  <p>Summing the 'Mark' ages &amp; then counting that aggregated number?</p>
  <p>Calculated field calculation is: <code>=COUNT(Age)</code></p>
  <p><a href="https://i.stack.imgur.com/dj4bu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dj4bu.png" alt="enter image description here" /></a></p>