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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|