sum formula for multiple criteria

[SURYA2016]

 

[DanteAmor]

Hi @SURYA2016

Try:

Dante Amor
	A	B	C	D	E	F	G	H	I	J
1	Area	Payment
2		Category	Amount	Category	Amount	Category	Amount	Category	Amount	Total
3	1	2	3	4	5	6	7	8	9	10(3+5+7+9)
4	Chennai	NEFT	250	ECS	250	DD	250	NEFT	250	1000
5	Sowcarpet	DD	1000	NEFT	250					1250
6	Mambalam	NEFT	250	ECS	250	DD	250	NEFT	250	1000
7	Parrys	DD	1250	ECS	250	DD	1000	NEFT	250	2750
8
9
10	Result
11	Area	NEFT	ECS	DD	Total
12	Chennai	500	250	250	1000
13	Sowcarpet	250	0	1000	1250
14	Mambalam	500	250	250	1000
15	Parrys	250	250	2250	2750
16	Total	1500	750	3750	6000
dam

Cell Formulas
Range	Formula
J4:J7	J4	=C4+E4+G4+I4
B12:D15	B12	=SUM(IFERROR(($A$4:$A$7=$A12)*($B$4:$H$7=B$11)*$C$4:$I$7,0))
E12:E15	E12	=SUM(B12:D12)
B16:E16	B16	=SUM(B12:B15)
Press CTRL+SHIFT+ENTER to enter array formulas.

Note XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------