I am trying to find a way to summarise data on a spreadsheet. I have
been searching around the newsgroups wothout much success.

I have written a Macro to download and format the report without too
many problems. However when it comes to summarising the data I am
finding it hard to find the right technique.

The Spreadsheet contains the following Columns -

Age - Type - Location - User

The Age is the age of the break created and goes from 0 - 300.

What I want to do is break down the type and amount of breaks for each
day. For example

Day 0

Type A - 15
Type B - 5
Type C - 10

Day 2

Type A - 5
Type B - 20
Type C - 25

But I only Want 1 Day, 2 Days, 3 Days or more.

I have tried pivot tables but I encounter problems when trying to count
the number of breaks over 3 days and removing the 100+ other days
broken down by the pivot table.

For this I eventually settled for using a template totals sheet and
using the SUMPRODUCT function to Calculate these fields. This is
sufficient for now but I am sure there will be new "types" added at a
later date and I would my macro to enter these fields rather than a
static template.

Is this possible? If you could point me in the right direction for
acheiving this I would be grateful !

If it is possible I would also like to create a breakdown by user as
well.

Thanks


Jamie