Home |
Search |
Today's Posts |
#1
|
|||
|
|||
From x date To x date you have earned x$ (dates are not the same)
COLUMN "A" HAS DATES IN IS AND COLUMN "E" HAS POINTS FOR THAT DATE.
A E 6/11/05 80 6/05/05 100 6/11/05 95 6/05/05 73 6/11/05 230 "I WANT TO PUT ANYWHERE ON THE SPREADSHEET (FROM _____ TO _______ YOU X POINTS) EXP. FROM 6/11/05 TO 6/11/05 YOU HAVE 405 POINTS) HELP THIS VERY IMPORTANT |
#2
|
|||
|
|||
On Sat, 11 Jun 2005 17:41:02 -0700, RODRODROD
wrote: COLUMN "A" HAS DATES IN IS AND COLUMN "E" HAS POINTS FOR THAT DATE. A E 6/11/05 80 6/05/05 100 6/11/05 95 6/05/05 73 6/11/05 230 "I WANT TO PUT ANYWHERE ON THE SPREADSHEET (FROM _____ TO _______ YOU X POINTS) EXP. FROM 6/11/05 TO 6/11/05 YOU HAVE 405 POINTS) HELP THIS VERY IMPORTANT If your first date is in D1, and your second date is in D2, then this formula: ="From "&TEXT(D1,"m/dd/yy")&" to "&TEXT(D2,"m/dd/yy")&" you have " &SUMIF(A:A,"="&D1,E:E)-SUMIF(A:A,""&D2,E:E)&" points." --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
Using a col of Dates by day I want to determine a wk ending date. | Excel Worksheet Functions | |||
Using a col of Dates by day I want to determine a wk ending date. | Excel Worksheet Functions |