This works below for 1 year BUT when I get more than 1 year it still just
looking at months.
ow can I change toe formula to look at years as well as months.

TiA

Mag()()



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

"Mag()()" wrote:

> 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
>
>
>