Sum with multiple criterias

Y

Yvon

Need some advice with a function...

I am working on a template for a sales budget by item and customer.
At the end, they all have to be consolidated into a single sheet. The
Consolidation template would look like this,

Item# Year Wk1 Wk 2 Wk 3 Wk4 .......................
11001 Sales2002
11001 Sales2003
11001 Budget2004

11002 Sales2002
11002 Sales2003
11002 Budget2004


The customer budget templates would look exactly the same but will not
list all items, but only items they purchase...

The consolidation template would sum all the customer templates by
item.

Your advice would be much appreciated!!!!

Thanks!
 
P

Pierre Leclerc

Hi

Discover the SUMPRODUCT formula

Download a free tutorial from:

http://www.excel-vba.com/free_excel_tutorial/index.htm



Need some advice with a function...

I am working on a template for a sales budget by item and customer.
At the end, they all have to be consolidated into a single sheet. The
Consolidation template would look like this,

Item# Year Wk1 Wk 2 Wk 3 Wk4 .......................
11001 Sales2002
11001 Sales2003
11001 Budget2004

11002 Sales2002
11002 Sales2003
11002 Budget2004


The customer budget templates would look exactly the same but will not
list all items, but only items they purchase...

The consolidation template would sum all the customer templates by
item.

Your advice would be much appreciated!!!!

Thanks!

Pierre Leclerc
http://www.excel-vba.com
(e-mail address removed)
 

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