View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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