On Sat, 7 Jan 2006 13:56:02 -0800, in
microsoft.public.excel.worksheet.functions you wrote:

got it
thank you very much
simpler than i was trying to make it


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