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

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

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