Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do this?
On Sat, 7 Jan 2006 13:56:02 -0800, in
microsoft.public.excel.worksheet.functions you wrote: two questions, 1 related why does the operand <= have to be in quotes? i see function is this group the contain (-- what is the significance of the double dash thanks Here you go...try this: F62: =SUMIF(A7:A61,"="&TODAY(),F7:F61) Does that help? *********** Regards, Ron XL2002, WinXP-Pro " wrote: col A are dates in the format of 01/01/06 row 7 thru 61 col f are dollar amounts row 7 thru 61 row 62 col f i want a total but only if the date in col a is = today() any ideas i've messed with thing long enough without results thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do this?
Excel will only accept a number, text, or an expression as the criteria of
the SUMIF function. In your case, I had to use an expression consisting of the less_than_or_equal operator (<=) prepended to today's date. Consequently, the formula is: =SUMIF(A7:A61,"="&TODAY(),F7:F61) Regarding the double-negative-sign. (--), that is typically used to convert a boolean value (TRUE or FALSE) to it's numeric equivalent: 1 or 0, respectively. The first dash makes TRUE equate to -1, the second dash converts -1 to +1. It could also be done by multiplying the value by 1, but the generally accepted convention is to use the double-negative-sign. Does that help? *********** Regards, Ron XL2002, WinXP-Pro " wrote: On Sat, 7 Jan 2006 13:56:02 -0800, in microsoft.public.excel.worksheet.functions you wrote: two questions, 1 related why does the operand <= have to be in quotes? i see function is this group the contain (-- what is the significance of the double dash thanks Here you go...try this: F62: =SUMIF(A7:A61,"="&TODAY(),F7:F61) Does that help? *********** Regards, Ron XL2002, WinXP-Pro " wrote: col A are dates in the format of 01/01/06 row 7 thru 61 col f are dollar amounts row 7 thru 61 row 62 col f i want a total but only if the date in col a is = today() any ideas i've messed with thing long enough without results thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do this?
Correction of a not-paying-attention typo:
Obviously, "less_than_or_equal operator (<=)" should have been: greater_than_or_equal operator (=) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Ron Coderre" wrote: Excel will only accept a number, text, or an expression as the criteria of the SUMIF function. In your case, I had to use an expression consisting of the less_than_or_equal operator (<=) prepended to today's date. Consequently, the formula is: =SUMIF(A7:A61,"="&TODAY(),F7:F61) Regarding the double-negative-sign. (--), that is typically used to convert a boolean value (TRUE or FALSE) to it's numeric equivalent: 1 or 0, respectively. The first dash makes TRUE equate to -1, the second dash converts -1 to +1. It could also be done by multiplying the value by 1, but the generally accepted convention is to use the double-negative-sign. Does that help? *********** Regards, Ron XL2002, WinXP-Pro " wrote: On Sat, 7 Jan 2006 13:56:02 -0800, in microsoft.public.excel.worksheet.functions you wrote: two questions, 1 related why does the operand <= have to be in quotes? i see function is this group the contain (-- what is the significance of the double dash thanks Here you go...try this: F62: =SUMIF(A7:A61,"="&TODAY(),F7:F61) Does that help? *********** Regards, Ron XL2002, WinXP-Pro " wrote: col A are dates in the format of 01/01/06 row 7 thru 61 col f are dollar amounts row 7 thru 61 row 62 col f i want a total but only if the date in col a is = today() any ideas i've messed with thing long enough without results thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|