Re: How to consolidate and sum data

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

In article <59b74c3d.-1@xxxxxxxxxxxxxxxxxxxxxxx>,
mfreund@xxxxxxxxxxxxxxxx wrote:

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a worksheet that is an export from a relational database, consisting
of a series of events for a group of individuals with multiple events for
each individual. The table lists each event on a separate line with a unique
identifier for the individual as one of the columns of the data.

I would like to summarize one of the fields (duration of event) by
individual, so that I get the sum (total duration of all events attended) for
each individual.

I tried playing with the Data: Consolidate menu item, but I can't find any
reference to it in the Help document or on this website.

(This is one of the infuriating things about how Microsoft fails to support
the Mac community -- providing software that doesn't even include full
documentation!)

If you think that's a Mac-centric problem, you haven't looked at the
Windows "documentation".


Anyway, read up on SUMIF. I can't tell from your description but it
sounds like that's what you want.

As they say in another data analysis group I frequent, " please supply
commented, minimal, self-contained, reproducible code."



As a result, I have no idea if Data: Consolidate is the right function to
use, or if there is a better way to accomplish what I'm looking to do. I
suspect Pivot Tables might be another, but I have not been able to figure out
how to get them to work.

Anybody have a suggestion? Or at least a place where I can read some
documentation on Data: Consolidate?

--
Team EM to the rescue! http://www.team-em.com
.

Relevant Pages

  • How to consolidate and sum data
    ... Mac OS X 10.5 ... I would like to summarize one of the fields (duration of event) by individual, so that I get the sum for each individual. ... As a result, I have no idea if Data: Consolidate is the right function to use, or if there is a better way to accomplish what I'm looking to do. ... Or at least a place where I can read some documentation on Data: ...
    (microsoft.public.mac.office.excel)
  • Re: Why has the Metrowerks sign been taken down?
    ... I worked on Mac OS X since DP4 came out. ... I asked questions on email lists when I needed. ... The documentation issue is probably the single most universal complaint ... the quality of said header ...
    (comp.sys.mac.programmer.codewarrior)
  • Re: Why has the Metrowerks sign been taken down?
    ... > web about how apps are already compiling and working with Mac OS X ... > to do it because of the documentation. ... - Large developers like Adobe and Microsoft have direct access to help ... of Apple engineers who contribute to those lists. ...
    (comp.sys.mac.programmer.codewarrior)
  • Re: Is any part of Ethernet circuitry tied to Open Firmware?
    ... things that constitute this overall problem that other Mac users are ... Apple supplies instructions for how to set up Boot Camp and Windows (XP ... with correct installation of the drivers. ... documentation, configuration or drivers for external devices are the ...
    (comp.sys.mac.system)