SUM with multiple match

[Ahmed Fawad]

Date	Head	SubHead	Description		Amount
01-Nov	Security		Paid to Mr. X		10,000.00
04-Nov	Salary	Oct	Khalid		15,000.00
05-Nov	Security	Utility	Electricity Bill		189,141.00
05-Nov	Security		Demand Note Electricity		4,000.00
05-Nov	Store		Peel Skin (10280 KG)		97,670.00
06-Nov	Security		Lineman Transformer		1,500.00
17-Nov	Misc.		Ex Supervisor		3,000.00
19-Nov	Security		Brooder		50,000.00
21-Nov	Salary	Oct	Dilshad Supervisor		5,000.00
21-Nov	Store		Feed 200 bags		600,000.00
22-Nov	Store		Screw Drivers	2	800.00

I need to calculate the total amount paid in Salary's head from the above table by names in the description.
i.e.

Name	Designation	Salary
Dilshad Supervisor	Supervisor	5000
Khalid	Watchman	15000

TIA

 

[hrayani]

=SUMIFS(F2:F12,D2:D12,A16,B2:B12,"Salary")

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Head	SubHead	Description		Amount			Name	Designation	Salary
2	01-Nov	Security		Paid to Mr. X		10,000.00			Dilshad Supervisor	Supervisor	5000
3	04-Nov	Salary	Oct	Khalid		15,000.00			Khalid	Watchman	15000
4	05-Nov	Security	Utility	Electricity Bill		189,141.00
5	05-Nov	Security		Demand Note Electricity		4,000.00
6	05-Nov	Store		Peel Skin (10280 KG)		97,670.00
7	06-Nov	Security		Lineman Transformer		1,500.00
8	17-Nov	Misc.		Ex Supervisor		3,000.00
9	19-Nov	Security		Brooder		50,000.00
10	21-Nov	Salary	Oct	Dilshad Supervisor		5,000.00
11	21-Nov	Store		Feed 200 bags		600,000.00
12	22-Nov	Store		Screw Drivers	2	800
13
14
Master

Cell Formulas
Range	Formula
K2:K3	K2	=SUMIFS(F:F,B:B,K$1,D:D,I2)