applying formula
 

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.

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.