how can i setup formula in excell

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.

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"darsg" <darsg@discussions.microsoft.com> wrote in message
news:BB0C4542-CD9C-420C-A184-CD8DC14BFB38@microsoft.com...
>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.

A guess:

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

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)

"darsg" wrote:

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