how do i do this?

  • Thread starter GeneralNuisance
  • Start date
G

GeneralNuisance

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
 
R

Ron Coderre

Here you go...try this:

F62: =SUMIF(A7:A61,">="&TODAY(),F7:F61)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top