Hi Terry,

Am Thu, 10 Mar 2016 11:06:51 +0000 schrieb Terry Pinnell:

I want to prepare a simple bar chart so must first produce a summary.

https://dl.dropboxusercontent.com/u/...ataToTable.jpg

do you want to count the different Suffixes of all years?
Can't you write the Suffixes in E1:J1?
Then you could use in E2:
=COUNTIFS($A:$A,$D2,$B:$B,E$1)
and copy down and to right.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional