Excel 2007 : How to count based on months and parts?

**WhieLion** · 06-14-2011, 03:26 AM

Hi

I am trying to make a formula to solve the below stated problem:

Expected product sales
Product - Composed of parts ---- Jan. - Feb. - Mar. etc.
044410 - 044410-10, 044410-30, --- 10 - 10 - 15
055510 - 044410-10, 055510-30, --- 13 - 10 - 20

How can I easily figure out how many parts I need for each month? I have tried counta, countif, sumproduct but am totally stuck.

Anyone who could help me out, please?

Thanks in advance!

Whi(t)eLion

**WhieLion** · 06-14-2011, 05:36 AM

Here I've attached the actual file I'm working on with a few other products and parts.

I was thinking to use three worksheets.
- Orders, where I write the expected orders
- Master Info with the "Product" and "Parts" connecting each other
- And lastly Stats where I clearly see how many parts I need for each month

I would really appreciate any and all hints/help.

Thanks again

Whi(t)eLion