close
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,quot;lt;quot;amp;TODAY()-60,I1:I12)
Adjust to suit your own ranges.--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.ukquot;Pat N.quot; lt;Pat gt; wrote in message
...
gt;I want to sum only some of the cells in a column, base on the date those
gt; payments are due. For example, add up all the bills over 60 days old.
全站熱搜
留言列表
