sumif

[Salamullah]

I have sales data with area & volume with sales value for both the years I want to bring total in the respective sales area, need formula when I will add new data it will automatically give results.

Data
	Year	Volume	Sales
A	2018	1	200
B	2018	2	300
A	2018	3	400
B	2018	4	550
A	2017	5	200
B	2017	6	300
A	2017	7	400
B	2017	8	550
		36	2900
Result required
	Volume	Sales
	2018	2017	2018	2017
A	4	12	600	600
B	6	14	850	850
TOTAL	10	26	1450	1450

<tbody>
</tbody><colgroup><col><col span="4"></colgroup>

 

[Peter_SSs]

Is this what you mean?
The formula in G3 is copied across to H3 and down to row 4.
The formula in I3 is copied across to J3 and down to row 4.

Book1
	A	B	C	D	E	F	G	H	I	J
1		Year	Volume	Sales			Volume		Sales
2	A	2018	1	200			2018	2017	2018	2017
3	B	2018	2	300		A	4	12	600	600
4	A	2018	3	400		B	6	14	850	850
5	B	2018	4	550		TOTAL	10	26	1450	1450
6	A	2017	5	200
7	B	2017	6	300
8	A	2017	7	400
9	B	2017	8	550
SUMIFS

Cell Formulas
Range	Formula
G3	=SUMIFS($C$2:$C$1000,$A$2:$A$1000,$F3,$B$2:$B$1000,G$2)
I3	=SUMIFS($D$2:$D$1000,$A$2:$A$1000,$F3,$B$2:$B$1000,I$2)

 

[Salamullah]

Yes perfect, thanks

 

[Peter_SSs]

Yes perfect, thanks

No problem. Glad it helped.