Multiple levels of summary/grouping

[marilyn934]

Can anyone tell me the easiests way to get totals when I have 5 different columns that I want to work with? Each station has multiple individuals who each have multiple invoices with multiple line items on each.
I want to end up with counts for each station that show total number of people, total number of invoices, total number of line items and total amount of dollars...

[Richard Buttrey]

Hi,

And welcome to the forum.

The Pivot Table functionality was designed precisely to address the summarisation and analysis you describe. You can build it in seconds and requires no formulae to make it work. Check it out.

[marilyn934]

But would that give me a sheet at the end with all of the totals on one sheet?