View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rosa59 Rosa59 is offline
external usenet poster
 
Posts: 7
Default count count multiple rows

You can use the Data-Subtotals feature. Select the table and headers and
choose "at each change in YEAR" to Count the rows and put the subtotal below
the data.

"Lise" wrote:

I have a spreadsheet with 2318 rows dates ranging from 2003 through to 2008 -
I would like to have the sheet split at the end of each year and count how
many rows are in each section - can this be done please
--
Thanks

Lise