You should be able to do that with the Sumif function. Say your data table
is A1:C4, and the department numbers you want to sum by are in E1:E2. In F1,
you'd enter
A pivot table will do that for you. On the data menu select Pivot Table and
follwo the wizard. Put your Departments in the left hand column and the
amounts in the data section. It will automatically create all of your totals
for you by department. You could also add supplier names and move things
around to suit. if you want to get fancy just add an autoformat and you will
get a very professional looking report...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
