Lookup & Add corresponding values for date range

[goble]

Hello,

Am trying to get total amount of values by year. Thanks for your help !

Date	Amount
01-Mar-23	15​
15-Aug-23	10​
25-Sep-24	20​
09-Dec-24​	18​
*** Results ***
Year	Sum
2023​	25​
2024​	38​

 

[Joe4]

One way:

Formula in cell B10:

=SUMPRODUCT(--(YEAR(A$2:A$5)=A10),(B$2:B$5))

and copy down to B11

 

[PeteWright]

= SUMPRODUCT( --(YEAR($A$2:$A$5)=A8) * ($B$2:$B$5))

 

[goble]

=SUMPRODUCT(--(YEAR(A$2:A$5)=A10),(B$2:B$5))

Perfect ! Thanks !

 

[Joe4]

You are welcome.
Glad we were able to help!

You can also use a SUMIFS formula, though it would be a little longer.
That is a great option is trying to total between two dates that may not necessarily be year start/end dates.
See: Excel SUMIFS date range formula - sum if between two dates

 

[goble]

You are welcome.
Glad we were able to help!

You can also use a SUMIFS formula, though it would be a little longer.
That is a great option is trying to total between two dates that may not necessarily be year start/end dates.
See: Excel SUMIFS date range formula - sum if between two dates

Many thanks, this is perfect when you want to keep track of your current sales figures (for this FY vs last FY).
Example Jan 2023 vs Jan 2024 and as such you'll know in real time how the sales are doing
I will for sure implement this solution as well.

Again thanks and have a wonderful day !