Summarization of Excel data

[Guest]

I need to summarize (subtotal) rows in an Excel spreadsheet. The subtotal command gets me part of the way there, but I need more functionality. I have 1000 records that I want to subtotal amount by customer number. But, I also need the customer name, address, record count, etc. in the subtotal record. I would like to be able to use an sql statement to do it, but don't know if possible. Any ideas?

 

[Eric]

I don't know, but it sound like a job for a pivot table to
me. As long as your dataset isn't dreadfully huge, I
think it would do the trick.

Eric

 

[Richard]

Try DATA, SUBTOTAL

This will most likely be what you need.

-----Original Message-----
I need to summarize (subtotal) rows in an Excel

spreadsheet. The subtotal command gets me part of the way
there, but I need more functionality. I have 1000 records
that I want to subtotal amount by customer number. But, I
also need the customer name, address, record count, etc.
in the subtotal record. I would like to be able to use an
sql statement to do it, but don't know if possible. Any
ideas?