Best way to subtotal this data?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello all,

I have a worksheet with a bunch of data that I need to extract certain
statistics from. I need to show the total number of hours charged by each
person to each group they worked in for the last year. So, I need to sort by
person, then by group, then by total number of hours in each. Each person
may or may not have any hours in any given group. Any suggestions?
.

Relevant Pages

  • Re: Double LOOKUP? Help please...
    ... If your statistics are all numbers, then the following array formula may ... My current project is based around the analysis of soccer player ... I have a worksheet which has a ... drop-down menu where you select the opposition. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: [ADMIN] useful things, charter, FAQs etc
    ... Richard Corfield wrote: ... I wrote a bunch of ... I think I posted an extract a couple of years ago. ... It would have to be a matrix wiki - topic by point of view - or have ...
    (uk.religion.christian)
  • "Indirect" references
    ... I have a complex spreadsheet that calculates statistics for my pool ... There are three databases stored in each worksheet. ... A typical formula on my Overall Statistics worksheet would look like ...
    (microsoft.public.excel)
  • population sums
    ... head around how to extract a total sum of individuals *that have ever ... (Granted I am an undergraduate and not yet taken any ... statistics classes.) ...
    (sci.bio.ecology)
  • Re: Pivot Table Grouping by Quarters
    ... If the returned data set is less than 65k rows you could use 'get ... external data' to extract the rows into a worksheet, ...
    (microsoft.public.excel.misc)