View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Satyendra_Haldaur[_2_] Satyendra_Haldaur[_2_] is offline
external usenet poster
 
Posts: 28
Default count count multiple rows

Dear Lise;

Why dont you make a Pivot table . you can make it yearwise and you can count
entries.it would be more useful then applying formulas in same sheet. if you
don't know send me your sheet. i will make a pivot and send you a vedio also.

"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