how can i setup formula in excell

[Guest]

i have got two sheets in sheet 1
A B C
29-Mar-05 30-May-05 7.00
31-May-05 24-Jun-05 39.00
25-Jun-05 01-Jul-05 46.00
In Sheet 2 i got...

01-Apr 7
02-Apr 7
03-Apr 7
04-Apr 7
05-Apr 7
06-Apr 7
07-Apr 7
08-Apr 7
09-Apr 7
10-Apr 7
11-Apr 7
12-Apr 7
13-Apr 7
14-Apr 7
can i put some formula to get it done automaticaly.

 

[JulieD]

Hi

can i put some formula to get it done automaticaly.

not sure on what "it" is, ie the thing you want to get done automatically
....
i can't see how 7 (whatever's) per day for April relate at all to

A B C
29-Mar-05 30-May-05 7.00
31-May-05 24-Jun-05 39.00
25-Jun-05 01-Jul-05 46.00

if you'ld like to explain your data and what you want to achieve with a few
more words i'm sure we can assist.

 

[P Sitaram]

A guess:

Try VLOOKUP eg., =VLOOKUP(A1,Sheet1!$C$1:$A$3,3)

 

[Guest]

If your sheet1 data are in A1:C3 and the sheet2 data start in A1:
=SUMPRODUCT((A1<=Sheet1!B1:B3)*(Sheet2!A1>=Sheet1!A1:A3)*Sheet1!C1:C3)