=SUMPRODUCT((S1:S10TODAY()-365)*(S1:S10<=TODAY())*(K1:K10))
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DB74" wrote:

I have a list of revenue by dates (mmyy) and want to have a function that
will calculate my revenue for the last 12 months as of today. Can anyone
help with the syntax of this function? My dates are in column S and my
revenue figures are in column K.

Thanks for your help!