| 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
=SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value
Does this make more sense now? 1st spreadsheet a1: ITR Summary a2: =today() 2nd spreadsheet Last Name Category1 Category2 Category3 3/12/08 3/13/08 3/14/08 Jia 3 2 5 SUM SUM SUM -- Jia Eclipser "T. Valko" wrote: ............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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Does this make more sense now?
Well, not really. Maybe a fresh set of eyes will see what I'm not seeing. -- Biff Microsoft Excel MVP "Jia" wrote in message ... =SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value Does this make more sense now? 1st spreadsheet a1: ITR Summary a2: =today() 2nd spreadsheet Last Name Category1 Category2 Category3 3/12/08 3/13/08 3/14/08 Jia 3 2 5 SUM SUM SUM -- Jia Eclipser "T. Valko" wrote: ............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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Maybe this is what you're trying to do:
http://img515.imageshack.us/img515/8348/sumva9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Does this make more sense now? Well, not really. Maybe a fresh set of eyes will see what I'm not seeing. -- Biff Microsoft Excel MVP "Jia" wrote in message ... =SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value Does this make more sense now? 1st spreadsheet a1: ITR Summary a2: =today() 2nd spreadsheet Last Name Category1 Category2 Category3 3/12/08 3/13/08 3/14/08 Jia 3 2 5 SUM SUM SUM -- Jia Eclipser "T. Valko" wrote: ............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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Nothing happens when I double click on the hyper link. *sighs*
Wannetta.Thomas @EclipseAviation -- Jia Eclipser "T. Valko" wrote: Maybe this is what you're trying to do: http://img515.imageshack.us/img515/8348/sumva9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Does this make more sense now? Well, not really. Maybe a fresh set of eyes will see what I'm not seeing. -- Biff Microsoft Excel MVP "Jia" wrote in message ... =SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value Does this make more sense now? 1st spreadsheet a1: ITR Summary a2: =today() 2nd spreadsheet Last Name Category1 Category2 Category3 3/12/08 3/13/08 3/14/08 Jia 3 2 5 SUM SUM SUM -- Jia Eclipser "T. Valko" wrote: ............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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum formulas based on date
Well, at this point there's not much more I can do unless you want to send
me a copy of the file or a sample file that shows me what you'e trying to do. If you can/want to do that I'm at: xl can help at comcast period net Remove "can" and change the obvious. If you do send me a file let me know in this thread. I don't always check that mail account. -- Biff Microsoft Excel MVP "Jia" wrote in message ... Nothing happens when I double click on the hyper link. *sighs* Wannetta.Thomas @EclipseAviation -- Jia Eclipser "T. Valko" wrote: Maybe this is what you're trying to do: http://img515.imageshack.us/img515/8348/sumva9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Does this make more sense now? Well, not really. Maybe a fresh set of eyes will see what I'm not seeing. -- Biff Microsoft Excel MVP "Jia" wrote in message ... =SUMIF(BL23:CY23,'ITR Summary'!A2,C23:M23) returned a zero value Does this make more sense now? 1st spreadsheet a1: ITR Summary a2: =today() 2nd spreadsheet Last Name Category1 Category2 Category3 3/12/08 3/13/08 3/14/08 Jia 3 2 5 SUM SUM SUM -- Jia Eclipser "T. Valko" wrote: ............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 | |||
Linear Mode
