One way;
=SUMPRODUCT(($A$3:$A$4<=A9)*($B$3:$B$4=A9)*($C$3: $C$4=$B9),D3:D4)
with A9 containing 4/3/2000, B9 containing John, C9 containing the formula
above.
"dom" wrote in message
...
for example
*table 1
A B C D
1 Start End User Rate
2 ----- ---- ----- -----
3 1.1.2000 31.12.2000 John $200
4 1.2.2001 31.12.2001 John $300
*table 2
A B C
1 Date User Rate
2 ----- ---- -----
3 3.4.2000 John ??? <--- preferred $200 as table1 "D3"
I want to get user "John" the Rate by the criteria between Start and End
from table 1, how can I do.
thanks