Sum formula

[Av8tordude]

I'm seeking help with a formula that will can sum the Blue box values base on the current year.

Example: From Aug 31 - Dec 31 totals: 17065.79. The values after Dec 31 should not be included in the sum. The dates in the red boxes are dynamic and will adjust as the current month passes. Example Aug 31 will display Sep 30 when September arrives.

 

[Eric W]

Maybe:

Book1
	A	B	C	D	E	F	G	H	I
1	8/31/2022	9/30/2022	10/31/2022	11/30/2022	12/31/2022	1/31/2023	2/28/2023	3/31/2023	4/30/2023
2
3
4
5
6	-863.03	-1386.37	7892.15	5065.52	6357.52	6357.52	6357.52	6357.52	6357.52
7
8
9	17065.79
Sheet4

Cell Formulas
Range	Formula
A9	A9	=SUMPRODUCT(A6:I6,--(YEAR(A1:I1)=YEAR(TODAY())))

 

[SanjayGMusafir]

I'm seeking help with a formula that will can sum the Blue box values base on the current year.

Example: From Aug 31 - Dec 31 totals: 17065.79. The values after Dec 31 should not be included in the sum. The dates in the red boxes are dynamic and will adjust as the current month passes. Example Aug 31 will display Sep 30 when September arrives.

View attachment 72670

Try this - Assuming Date is in Cell A1 & Blue Cells start Cell F1

=SUMIFS(F1:F9,A$1,">="&Date(Year($A$1),1,1),A$1,"<="&Date(Year($A$1),12,31))