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