Sumif date range

DB74 · May 9, 2008

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> · May 9, 2008

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

DB74 · May 9, 2008

Thnaks for your help! This worked great.

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

Sumif date range

DB74

KC Rippstein hotmail com>

DB74