M
Mag\(\)\(\)
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
2))
Copy the formula down, and multiply the result by the price in column f.
Regards
Peter
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
2))Copy the formula down, and multiply the result by the price in column f.
Regards
Peter