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.

Pat,

Try:

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

Adjust to suit your own ranges.


--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"Pat N." <Pat N.@discussions.microsoft.com> wrote in message
news:481090D1-4BD4-432E-BE44-1100F46F7DED@microsoft.com...
>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.