Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

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