Two dimensional sum by week
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
|