Hi Jon,
I can't follow your example -- it looks incomplete, but you seem to know
exactly what you want, Pivot Tables, and you seem to know your data,
so you can probably look at some web pages concerning Pivot Tables
and solve your problem.

look for Pivot Table entries in index
http://www.contextures.com/tiptech.html

look for Pivot Table entries in index -- these are flash presentations ***
http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jon" wrote in message ...
worksheet contains holiday info and looks like...

Date Name1 Name2 Name3
1/1/05
2/1/05
.
.
31/12/05

at the intersection of name & date a number 1 indicates a holiday

I'm trying to create a summary/pivot table (ultimately for use elsewhere in
the workbook) which will show...

Name,Week 1,Week 2.....
Name1,sum of hol,
Name2
Name3
...

I can't TRANSPOSE the data initially as the max no. of columns is 256 and
there are 365+ days in a year

Any suggestions much appreciated.