Sumif date range

[DB74]

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!

 

[KC Rippstein hotmail com>]

=SUMPRODUCT((S1:S10>TODAY()-365)*(S1:S10<=TODAY())*(K1:K10))

 

[DB74]

Thnaks for your help! This worked great.

=SUMPRODUCT((S1:S10>TODAY()-365)*(S1:S10<=TODAY())*(K1:K10))