Searching a column multiple times for a value / returning a running total of values

J

Jeff King

Hi,
Please bear with me as this post may be long.
Any help with this problem is greatly appreciated. Using Excel97.

I have a workbook where each sheet is a monthly summary of $ values
for jobs done and who the job is for. (along with alot of other info).

What i am trying to do is:

1) Search through column E for each individual company name and
create a running total of billed amounts in another worksheet named
Summary.

2) Store the name of each company and the total of all money billed
to them in another worksheet named Summary.

3) Use the Summary sheet to keep track of company billing for month
after month.

format for Summary sheet is:
Company name Month 1 Month 2 Month 3 etc
Company 1 $xxxx $yyyy $zzzz
Company 2 $aaaa $bbbb $cccc


$xxxx - this is a total of all the amounts in October's sheet where
company 1 is found

etc.

Thanks for any help.

Jeff King
 

Ask a Question

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.

Ask a Question

Top