Thread
:
applying formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
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.
Reply With Quote