Formula for last 6 months data and future 6 months

[krk1002]

Looking for a formula in B4 to

give total of values in Row 4 for past 6 months and future 6 months ​

using current date in A1 and months in Row 3.
Given today's date, that would mean Q4:AB4.

https://imgur.com/a/smDDTZ1

 

[alansidman]

You would want to use the =Sumifs formula. Here is a tutorial on how to use it with dates

https://exceljet.net/formula/sum-if-date-is-between

 

[mse330]

Try the below formula ... Adjust the range as per your file format C3:AV3

=SUMIFS(C4:AV4,C3:AV3,">="&EDATE(A1,-6),C3:AV3,"<="&EDATE(A1,6))

 

[sheetspread]

Excel 2010
	A	B	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	7/24/2018
2		Total
3	Month		1/1/2018	2/1/2018	3/1/2018	4/1/2018	5/1/2018	6/1/2018	7/1/2018	8/1/2018	9/1/2018	10/1/2018	11/1/2018	12/1/2018	1/1/2019	2/1/2019
4	Value	2375	375	100	100	200	300	225	150	375	100	100	200	300	225	150
Sheet7

Cell Formulas
Range	Formula
B4	=SUMIFS($P$4:$AC$4,$P$3:$AC$3,">="&EOMONTH($A$1,-6)+1,P$3:$AC$3,"<="&EOMONTH($A$1,6))