So, I just fooled around with your "SUMIF" code, and realized what it does,
it adds Amounts from only a certain department, but I'm still clueless as to
how to incorporate this into a formatted report by department?



"DannyS" wrote:

Why not use SUMIF?

SUMIF(A:A,"Sales",B:B)

If departments are in col A and costs in col B

"SarahT413" wrote:


Thanks, Bill,

But, I've already tried Pivot Tables and Pivot Chart Reports, and it tells
me that the Pivot Table Field Name is not valid and that I need to use data
that is organized as a list with labeled columns (it is). I have tried to
trouble-shoot Pivot Tables to no avail.

"Bill Ridgeway" wrote:

"SarahT413" wrote in message
...
I have expenses listed in a spreadsheet and I want to separate the data
into
departments in order to give a monthly expense status report to each
department head?

Another job for Pivot Table!! Have a look at <Data<Pivot Table and Pivot
Chart Report.

Bill Ridgeway
Computer Solutions