Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif date range | Excel Worksheet Functions | |||
SumIf with date range | Excel Worksheet Functions | |||
Sumif for Date Range | Excel Discussion (Misc queries) | |||
Sumif with two criteria including a date range | Excel Discussion (Misc queries) | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions |