sum after vlookup?

sum after vlookup?

am 23.04.2008 18:15:01 von myname

I have all the dates of the year in a column with a $ amount asociated with
the date in the column next to it. How I imagine this working is vlookup a
Starting date and then sum the following 2 dates after including that day (3
total days). Any idea if there is a preexisting function that will do this?

Thanks in advance. Here's an example...

I want to be able to enter a date (3/5/08) and a number of days (3) and the
formula will sum the dollar amount associated with 3/5/08 and the 2 days
after 50+70+120 and return the sum $240.

3/4/08 $100
3/5/08 $50
3/6/08 $70
3/7/08 $120
3/8/08 $60

Re: sum after vlookup?

am 23.04.2008 19:39:00 von Mike Mueller

The best advice I can give is to search a newgroup that deals with Excel-
this newsgroup is for the web application software, Front Page


"Adam" wrote in message
news:37DDC64B-8805-4DD3-91E9-98470F58666F@microsoft.com...
>I have all the dates of the year in a column with a $ amount asociated with
> the date in the column next to it. How I imagine this working is vlookup
> a
> Starting date and then sum the following 2 dates after including that day
> (3
> total days). Any idea if there is a preexisting function that will do
> this?
>
> Thanks in advance. Here's an example...
>
> I want to be able to enter a date (3/5/08) and a number of days (3) and
> the
> formula will sum the dollar amount associated with 3/5/08 and the 2 days
> after 50+70+120 and return the sum $240.
>
> 3/4/08 $100
> 3/5/08 $50
> 3/6/08 $70
> 3/7/08 $120
> 3/8/08 $60