 <p>I have a feeling there is an easier way but meanwhile, assuming you want to the count of <code>2</code> for <code>Rejected</code> to be of <code>System</code>s <code>S102</code> and <code>S103</code> and assuming Status is in <code>C1</code> and no blank row: </p> <p>Add a helper column (say D, labelled say <code>SR</code>) with: </p> <pre><code>=A2&amp;B2 </code></pre> <p>copied down to suit. Create a PivotTable from all four columns, with <code>System</code> for ROWS, Max of <code>Revision</code> for Sigma VALUES. Assuming the PT is in F:G starting Row1, add: </p> <pre><code> =INDEX(C:C,MATCH(F2&amp;G2,D:D,0)) </code></pre> <p>in H2 and copy down to suit. In I2: </p> <pre><code>=COUNTIF(H:H,H2) </code></pre> <p>in I3: </p> <pre><code>=COUNTIF(H:H,H3) </code></pre> <p>or change H2 and H3 in the formulae to "Accepted" and "Rejected".</p>