I missed your dates, but Jon suggested something that may make it a little
easier. I'd try that, too.

Jon C wrote:

Good idea. I'll give it a go.

Thanks.

-----Original Message-----
I'd add a fourth column, labeled 'Week Commencing'. The
formula in D2 would
be =a2 + 1 - weekday(a2).
That formula can be copied down to all your table rows.
Then just create a
pivot table report, with 'Week Commencing' as your
column header, 'Name' as
your row header, and 'Sum of Hours' as your data. (If
you haven't used Pivot
tables, just highlight columns A through D, then go to
the menu bar and
select Data, Pivot Table and Pivot Chart report...).
One caveat about Pivot tables: they won't automatically
reflect updates to
your data. To refresh, right-click in the Pivot table
and select refresh
data.


"Jon C" wrote:

Hi,

I've got a problem relating to summing daily totals,
by
an individual, by week.

Here's my source data:

Date Name Hrs
21/02/2005 John 11
22/02/2005 John 9
23/02/2005 George 7
23/02/2005 Fred 7.5
24/02/2005 John 9
24/02/2005 Fred 7.5
etc.

What I'd like to produce is a table something like
this:

Week Commencing 21/2 28/2 7/3
John
George
Fred

And at the intersect, have the total hours worked
during
that week. I guess some form of two dimensional SUMIF?

Any ideas?

Thanks,

Jon C


.


--

Dave Peterson