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
|