View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default applying formula

Pat,

Try:

=SUMIF(H1:H12,"<"&TODAY()-60,I1:I12)

Adjust to suit your own ranges.


--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Pat N." <Pat wrote in message
...
I want to sum only some of the cells in a column, base on the date those
payments are due. For example, add up all the bills over 60 days old.