Summarising entries

[David Morrison]

I have been collecting data in an Excel spreadsheet, and want to try to
get some summary information out of it. I don't know if Excel can do it,
but if it can, I don't quite know how to tackle it. I would be grateful
for any examples or advice.

I have a spreadsheet where data is being entered chronologically. Let's
think of it as sales information. There are columns for date, time,
customer and sale price.

What I would like to do is to be able to get a summary of sales per
customer, probably on a separate worksheet.

So what would be needed is some way to get a total of all the entries in
a column for each customer name.

(I could just have a column for each customer in the chronological
worksheet, but this would be tedious given that there are dozens of
customers.)

So if anyone has any ideas, I would be grateful.

Thanks

 

[CyberTaz]

Hi David;

There are several options, such as the SUMIF or DSUM functions as well as
the Conditional Sum feature from the Tools menu.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Mike Middleton]

David Morrison -

If you verify that your data are arranged in standard database form (an
Excel "list" or "table"), you could use the Pivot Table feature to produce
reports.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[David Morrison]

Hi David;

There are several options, such as the SUMIF or DSUM functions as well as
the Conditional Sum feature from the Tools menu.

SUMIF and COUNTIF did it for me, but I'll have to have a further look at
DSUM for future use.

Thanks very much for the tip.

David