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
|