Question about numbers lined up against dates

  • Thread starter Thread starter Mag\(\)\(\)
  • Start date Start date
M

Mag\(\)\(\)

Hey all,
Lets see if I can explain this one.....

In Column "A" I have a series pf part number- IE 123, 442, ER45 and a whole
load of others.
In Column "B" I have a price against each part number IE £45.00, £6.70 and
others
In column "C" I have delivery dates against each part. IE - 2/3/06, 3/6/08
and lots of others.
Part number 123 may be required 2/3/06 and 28/3/06 and also 6/6/08 and is
£45 each
What I am looking for is a formula that shows part number 123 totals monthly
amounts. So part number 123 will show 2 required in March 06 at a value of
£90 and 1 required for Aug 08 at a value of £45.

Hope this makes sense.

Please help
TiA

magOO
 
mag

A= #ID, B= Price, c = DueDAte, D= Qty, E= Numb Due
formula in e2:
=SUMPRODUCT(--(MONTH($C$2:C2)=MONTH(C2)*(--($A$2:A2=A2)))*($D$2:D2))

Copy the formula down, and multiply the result by the price in column f.

Regards
Peter
 
Back
Top