No doubt someone here will have an answer for this one..

I have a table with hundreds of customers in column A and their sales volumes per month in the adjoining 10 columns.

I have a second table with around 80 customers and their sales volume of a specific product stream in the adjoining 10 columns.

I want excel to show the sales volume for each customer listed in the second table minus the volume for the specific product stream.

I need to show this for Jan through Oct for each of the 80.

Does that make sense?

I thought I could do it with vlookup, but tied myself in a knot.

Can you give us the specifics of the layouts, I'm not quite sure what you're wanting to remove from which other figure?

Sorry, work FW won't let me access photobucket to post a pic, and trying to post a table in here looks like hell.

The 80 customers in the second table are also listed in table one, but table one shows their overall sales.

I still want to show overall monthly sales in table one but, for those 80 customers I want to subtract the sales volumes in table two from the total sales for each month in table one.

Assuming that there are 2 tabs (one for all sales and one for product sales) and that column A has the customer name and then columns b-k have the sales figures in both cases, I think the following formula would work..

=SUMIF(All!A2:A9, A3, All!B2:B9)-SUMIF(Product!A2:A9, A3, Prod_A!B2:B9)

Where column A on the new table also has the customer name. Change B to C-K for each month.

Hope this makes sense (and helps).

Thanks Richard,

That works for the first few entries then fails for some reason, I'll have a play around with it.

[edit] just had to lock a few cell references and it worked fine. Thanks again

I love it when a formula cones together.