From data to summary?
Hi Terry,
Am Thu, 10 Mar 2016 12:17:46 +0100 schrieb Claus Busch:
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.
or an easier suggestion:
Select your data = Insert = PivotChart
Drag the years into the row range and the suffix into column range and
into values.
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|