ExcelBanter - Sumif date range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumif date range (https://www.excelbanter.com/excel-discussion-misc-queries/186857-sumif-date-range.html)

DB74

Sumif date range

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>

Sumif date range

=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!

DB74

Sumif date range

Thnaks for your help! This worked great.

"KC Rippstein" wrote:

=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!

All times are GMT +1. The time now is 10:03 AM.