What functions would I use to get money values over 30, 60, and 90 days old?

Originally Posted by Bryan Hessey

Hi,

yes, the formula were for the more usual figures where the 30 day figure excludes the 60 day, and the 60 day excludes the 90 day, and the 90 day excludes the 120 day etc. The Sumproduct version for your newly amended figures would be

=SUMPRODUCT(--(C9:C100<TODAY()-30)*(D9:D100))
=SUMPRODUCT(--(C9:C100<TODAY()-60)*(D9:D100))
=SUMPRODUCT(--(C9:C100<TODAY()-90)*(D9:D100))

which would agree with the figures shown, but this can also be achieved via the Sumif with a helper column as you have discoverd.

HI Bryan,

Thanks again for your information, I was looking for a way of using a formula without a helper column as you specified. This will help quite a bit in on coming projects.

I overlooked the possibility of boxing in a display amounts criticed in specific days, your second set of formula's will work well for this, ic.. 31-60 days, 61-90 days, etc...

My problem now is that, I only understand the basics in using Excel, and don't understand or see how the calculation steps work in the formula above, which does work well for this application.
Is there a place on line I can school/study on my own to get a better understanding on this works.

For instance, what does the "--" stand for in SUMPRODUCT(--(C9:C100<TODAY()-30)*(D9:D100))?
I see that "(C9:C100<TODAY()-30)" looks for every thing that is over 30 days, but how does "*(D9:D100)" give me the end result.
Obviously I have a bit to learn, so do you have a suggestion on where to start?

Thanks,
Dallas