| 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 | |||
Linear Mode
