Need to Show SUM of Multiple Columns Based on Criteria

[mfarhankhan87]

Hello Everyone,

I hope everyone is doing great. I need to show sum of multiple columns based on months in the summary sheet under year to date columns (highlighted in light blue).

I have applied the formula for the reporting month, now I want to show the sum of July+August, if August is selected in the reporting month Cell, or, July+August+September if September is selected and so on.

I have tried different formulas but I am unable to get any result on this. Can somebody help me out in developing a formula for this issue?

screenshots are attached for your references.

I would be really thankful.

Best Wishes.

Farhan

 

[earthworm]

Use below concept to calculate total between two date

Book1
	A	B	C	D	E
1	Date	Values
2	1-Aug-21	808.00		Date To	5-Aug-21
3	2-Aug-21	18,770.00		Date From	10-Aug-21
4	3-Aug-21	34,012.00		Answer	298,301.00
5	4-Aug-21	1,365.00
6	5-Aug-21	91,868.00
7	6-Aug-21	66,720.00
8	7-Aug-21	14,462.00
9	8-Aug-21	8,791.00
10	9-Aug-21	98,328.00
11	10-Aug-21	18,132.00
12	11-Aug-21	65,731.00
13	12-Aug-21	39,846.00
14	13-Aug-21	86,506.00
15	14-Aug-21	48,209.00
16	15-Aug-21	68,341.00
17	16-Aug-21	60,251.00
18	17-Aug-21	48,844.00
19	18-Aug-21	65,470.00
20	19-Aug-21	28,365.00
21	20-Aug-21	77,293.00
Sheet1

Cell Formulas
Range	Formula
E4	E4	=SUMIFS($B$2:$B$176,$A$2:$A$176,">="&$E$2,$A$2:$A$176,"<="&$E$3)

 

[Peter_SSs]

Welcome to the MrExcel board!

You will generally get better/faster help if you give us sample data in a form that we can copy from to test. So I suggest that you investigate XL2BB

I have assumed that the dates in row 1 of the Budget(?) sheet and D1 of the Summary sheet are real dates (numbers). Since it appears the main data only starts from July there should be no need to worry about the starting date for the Year to Date calculations.
Anyway, you could give something like this a go to see if it suits what you are trying to do.

mfarhankhan87.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N	O
13	Mat.Code	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22
14	1001	1	6	7	4	4	7	5	6	4	5	8	9
15	1002	8	6	7	1	4	6	4	5	2	9	8	2
16	1003	7	5	3	7	3	4	1	8	2	6	7	8
Budget

mfarhankhan87.xlsm
	A	B	C	D	E	F
1			Reporting Month	August-21
2
3
4					YTD
5						Budget
6	1003					12
7	1002					14
8	1001					7
Summary

Cell Formulas
Range	Formula
F6:F8	F6	=SUMPRODUCT((Budget!D$13:O$13<=D$1)*(Budget!C$14:C$16=A6),Budget!D$14:O$16)

 

[mfarhankhan87]

Thank you very much Peter, It worked like a charm. Have a great day ahead!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.