Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

Links

XODOX
Impressum

#1: sum after vlookup?

Posted on 2008-04-23 18:15:01 by 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

Report this message

#2: Re: sum after vlookup?

Posted on 2008-04-23 19:39:00 by 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" <myname@discussions.microsoft.com> 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

Report this message