If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running total based upon current date
I have cells with dollar values from formulas and i am trying to place the
total of all those values in another cell based upon the current date backwards. An IF gives me a #name result. I know i am not using the Date command properly, but i can't figure out how to do it. can anyone help me? I used =IF(Date=TODAY, sum(. ... Or is there a better way to do it? What i want is if the date is today or inthe past to add the dollar values in the cells, but not the ones that are in the future. |
#2
|
|||
|
|||
Running total based upon current date
Hi,
Change the ranges to suit =SUMPRODUCT((A1:A20"")*(A1:A20=TODAY())*(B1:B20 )) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: I have cells with dollar values from formulas and i am trying to place the total of all those values in another cell based upon the current date backwards. An IF gives me a #name result. I know i am not using the Date command properly, but i can't figure out how to do it. can anyone help me? I used =IF(Date=TODAY, sum(. ... Or is there a better way to do it? What i want is if the date is today or inthe past to add the dollar values in the cells, but not the ones that are in the future. |
#3
|
|||
|
|||
Running total based upon current date
Mike, being the usual slow thinking person i can sometimes be, i think a left
an important bit of info out. ... can i send you a copy that work sheet? The columns are titled with the months of the year and those that are in the future i don't want included but the ones that have passed i do. "Mike H" wrote: Hi, Change the ranges to suit =SUMPRODUCT((A1:A20"")*(A1:A20=TODAY())*(B1:B20 )) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: I have cells with dollar values from formulas and i am trying to place the total of all those values in another cell based upon the current date backwards. An IF gives me a #name result. I know i am not using the Date command properly, but i can't figure out how to do it. can anyone help me? I used =IF(Date=TODAY, sum(. ... Or is there a better way to do it? What i want is if the date is today or inthe past to add the dollar values in the cells, but not the ones that are in the future. |
#4
|
|||
|
|||
Running total based upon current date
Hi,
With the obvious changes M dot L dot hughes at virginmedia dot com -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: Mike, being the usual slow thinking person i can sometimes be, i think a left an important bit of info out. ... can i send you a copy that work sheet? The columns are titled with the months of the year and those that are in the future i don't want included but the ones that have passed i do. "Mike H" wrote: Hi, Change the ranges to suit =SUMPRODUCT((A1:A20"")*(A1:A20=TODAY())*(B1:B20 )) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: I have cells with dollar values from formulas and i am trying to place the total of all those values in another cell based upon the current date backwards. An IF gives me a #name result. I know i am not using the Date command properly, but i can't figure out how to do it. can anyone help me? I used =IF(Date=TODAY, sum(. ... Or is there a better way to do it? What i want is if the date is today or inthe past to add the dollar values in the cells, but not the ones that are in the future. |
#6
|
|||
|
|||
Running total based upon current date
To get the sum for 2011 for the 1st one for both rows. If this is what you
want? =SUM(A8:OFFSET(A8,1,MONTH(TODAY()))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... If mike is not avail If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "ucastores" wrote in message ... Mike, being the usual slow thinking person i can sometimes be, i think a left an important bit of info out. ... can i send you a copy that work sheet? The columns are titled with the months of the year and those that are in the future i don't want included but the ones that have passed i do. "Mike H" wrote: Hi, Change the ranges to suit =SUMPRODUCT((A1:A20"")*(A1:A20=TODAY())*(B1:B20 )) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ucastores" wrote: I have cells with dollar values from formulas and i am trying to place the total of all those values in another cell based upon the current date backwards. An IF gives me a #name result. I know i am not using the Date command properly, but i can't figure out how to do it. can anyone help me? I used =IF(Date=TODAY, sum(. ... Or is there a better way to do it? What i want is if the date is today or inthe past to add the dollar values in the cells, but not the ones that are in the future. |
Thread Tools | |
Display Modes | |
|
|