| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically Change date in Formula
I Manually add the date in the first column, and then I have a formula
that adds all of the figures for that day, =SUMIF($A$1:$A $1004,"=01/01/01",$C$1:$C$1004) Is there any way that I can change this so that the formula reflects the date that I placed in column 1 automatically. Right now I have about 6 cells that i have to manually change the date in the formula for. This is a daily process, and I CAN live without it, but it would sure be nice if this could be done. Thanks, Midget |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamically Change date in Formula
Use a cell to hold the date variable:
E1 = some date =SUMIF($A$1:$A$1004,$E$1,$C$1:$C$1004) Biff "Midget" wrote in message oups.com... I Manually add the date in the first column, and then I have a formula that adds all of the figures for that day, =SUMIF($A$1:$A $1004,"=01/01/01",$C$1:$C$1004) Is there any way that I can change this so that the formula reflects the date that I placed in column 1 automatically. Right now I have about 6 cells that i have to manually change the date in the formula for. This is a daily process, and I CAN live without it, but it would sure be nice if this could be done. Thanks, Midget |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamically Change date in Formula
Worked like a champ Biff, i don't know why that was so difficult for
me to figure out. Thanks for the tip! Midget On Feb 8, 2:50 pm, "T. Valko" wrote: Use a cell to hold the date variable: E1 = some date =SUMIF($A$1:$A$1004,$E$1,$C$1:$C$1004) Biff "Midget" wrote in message oups.com... I Manually add the date in the first column, and then I have a formula that adds all of the figures for that day, =SUMIF($A$1:$A $1004,"=01/01/01",$C$1:$C$1004) Is there any way that I can change this so that the formula reflects the date that I placed in column 1 automatically. Right now I have about 6 cells that i have to manually change the date in the formula for. This is a daily process, and I CAN live without it, but it would sure be nice if this could be done. Thanks, Midget- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamically Change date in Formula
Sometimes we just can't see the answer even though it's right in front of
us. I've been there countless times! Thanks for the feedback! Biff "Midget" wrote in message ups.com... Worked like a champ Biff, i don't know why that was so difficult for me to figure out. Thanks for the tip! Midget On Feb 8, 2:50 pm, "T. Valko" wrote: Use a cell to hold the date variable: E1 = some date =SUMIF($A$1:$A$1004,$E$1,$C$1:$C$1004) Biff "Midget" wrote in message oups.com... I Manually add the date in the first column, and then I have a formula that adds all of the figures for that day, =SUMIF($A$1:$A $1004,"=01/01/01",$C$1:$C$1004) Is there any way that I can change this so that the formula reflects the date that I placed in column 1 automatically. Right now I have about 6 cells that i have to manually change the date in the formula for. This is a daily process, and I CAN live without it, but it would sure be nice if this could be done. Thanks, Midget- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| formula to change color of a cell when date is over a year old? | New Users to Excel | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Formula to change number into date | Excel Discussion (Misc queries) | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
Linear Mode
