| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum formulas based on date
How do I create a formula that will sum up a row based upon a particular date?
-- Jia Eclipser |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
You need to provide some details! Like:
Where is the data you want to sum? What is its relationship to a particuler date(s)? Where is the date(s)? -- Biff Microsoft Excel MVP "Jia" wrote in message ... How do I create a formula that will sum up a row based upon a particular date? -- Jia Eclipser |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
*smiles sheepishly*
2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value of zero 1st worksheet: ITR SummaryA2 is actually =today() I need to calculate the amount of hours worked per project, per day -- Jia Eclipser "T. Valko" wrote: You need to provide some details! Like: Where is the data you want to sum? What is its relationship to a particuler date(s)? Where is the date(s)? -- Biff Microsoft Excel MVP "Jia" wrote in message ... How do I create a formula that will sum up a row based upon a particular date? -- Jia Eclipser |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Ok, we're making progress!
=SUMIF('ITR Summary'!A2,(C23:M23)) I assume C23:M23 are the values you want to sum. 'ITR Summary'!A2 =TODAY() Now, where are the dates that correspond to C23:M23? I'll assume they're in C22:M22 =SUMIF(C22:M22,'ITR Summary'!A2,C23:M23) -- Biff Microsoft Excel MVP "Jia" wrote in message ... *smiles sheepishly* 2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value of zero 1st worksheet: ITR SummaryA2 is actually =today() I need to calculate the amount of hours worked per project, per day -- Jia Eclipser "T. Valko" wrote: You need to provide some details! Like: Where is the data you want to sum? What is its relationship to a particuler date(s)? Where is the date(s)? -- Biff Microsoft Excel MVP "Jia" wrote in message ... How do I create a formula that will sum up a row based upon a particular date? -- Jia Eclipser |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Oh dang, that's not how I set up the spreadsheet. *sighs*
Here's a quick overview... Last Name Category1 Category2 Category3 Date Date Date Any recommendations? -- Jia Eclipser "T. Valko" wrote: Ok, we're making progress! =SUMIF('ITR Summary'!A2,(C23:M23)) I assume C23:M23 are the values you want to sum. 'ITR Summary'!A2 =TODAY() Now, where are the dates that correspond to C23:M23? I'll assume they're in C22:M22 =SUMIF(C22:M22,'ITR Summary'!A2,C23:M23) -- Biff Microsoft Excel MVP "Jia" wrote in message ... *smiles sheepishly* 2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value of zero 1st worksheet: ITR SummaryA2 is actually =today() I need to calculate the amount of hours worked per project, per day -- Jia Eclipser "T. Valko" wrote: You need to provide some details! Like: Where is the data you want to sum? What is its relationship to a particuler date(s)? Where is the date(s)? -- Biff Microsoft Excel MVP "Jia" wrote in message ... How do I create a formula that will sum up a row based upon a particular date? -- Jia Eclipser |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
............A................B.................C.. ...........D.......E.........F...
1...Category1...Category2...Category3...Date...Dat e...Date 2.........5.................7.................3... ...........x..................x.. x = today's date =SUMIF(D2:F2,'ITR Summary'!A2,A2:C2) -- Biff Microsoft Excel MVP "Jia" wrote in message ... Oh dang, that's not how I set up the spreadsheet. *sighs* Here's a quick overview... Last Name Category1 Category2 Category3 Date Date Date Any recommendations? -- Jia Eclipser "T. Valko" wrote: Ok, we're making progress! =SUMIF('ITR Summary'!A2,(C23:M23)) I assume C23:M23 are the values you want to sum. 'ITR Summary'!A2 =TODAY() Now, where are the dates that correspond to C23:M23? I'll assume they're in C22:M22 =SUMIF(C22:M22,'ITR Summary'!A2,C23:M23) -- Biff Microsoft Excel MVP "Jia" wrote in message ... *smiles sheepishly* 2nd worksheet: =SUMIF('ITR Summary'!A2,(C23:M23)) this returned a value of zero 1st worksheet: ITR SummaryA2 is actually =today() I need to calculate the amount of hours worked per project, per day -- Jia Eclipser "T. Valko" wrote: You need to provide some details! Like: Where is the data you want to sum? What is its relationship to a particuler date(s)? Where is the date(s)? -- Biff Microsoft Excel MVP "Jia" wrote in message ... How do I create a formula that will sum up a row based upon a particular date? -- Jia Eclipser |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas based on a date | Excel Worksheet Functions | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| Sumproduct based which also weights data based on date | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Hybrid Mode
