Need help summing values that intersect with stated criteria!

[bs123rh]

Hi, I have a table with property names on the X axis and account types on the Y axis. I need to sum all the values that meet the criteria for property name and account type on a different sheet. For example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]Haren Dr.[/TD]
[TD]Wright Rd.[/TD]
[TD]Summer Ln.[/TD]
[TD]Fox Hill Rd.[/TD]
[TD]Mallard Ln.[/TD]
[/TR]
[TR]
[TD]Asset
[/TD]
[TD]Cash[/TD]
[TD]500[/TD]
[TD]700[/TD]
[TD]1,000[/TD]
[TD]200[/TD]
[TD]900[/TD]
[/TR]
[TR]
[TD]Asset[/TD]
[TD]Land[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]600[/TD]
[TD]700[/TD]
[/TR]
[TR]
[TD]Asset[/TD]
[TD]Building[/TD]
[TD]500[/TD]
[TD]900[/TD]
[TD]300[/TD]
[TD]500[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]Liability[/TD]
[TD]A/P[/TD]
[TD]-50[/TD]
[TD]-60[/TD]
[TD]-40[/TD]
[TD]-20[/TD]
[TD]-50[/TD]
[/TR]
[TR]
[TD]Liability[/TD]
[TD]Security[/TD]
[TD]-20[/TD]
[TD]-20[/TD]
[TD]-20[/TD]
[TD]-20[/TD]
[TD]-20[/TD]
[/TR]
[TR]
[TD]Liability[/TD]
[TD]Loan Payable[/TD]
[TD]-200[/TD]
[TD]-300[/TD]
[TD]-400[/TD]
[TD]-500[/TD]
[TD]-600[/TD]
[/TR]
</tbody>[/TABLE]

So if I wanted to sum all assets for Wright Rd, I would be looking to find a value of (700+400+900) 2,000.

Thanks!

 

[JoeMo]

The two criteria are listed in I1:I2 and the sum in J2.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	*	*	Haren Dr.	Wright Rd.	Summer Ln.	Fox Hill Rd.	Mallard Ln.	*	Wright Rd.	Sum
2	Asset	Cash	500	700	1,000	200	900	*	Asset	2000
3	Asset	Land	300	400	500	600	700	*	*	*
4	Asset	Building	500	900	300	500	400	*	*	*
5	Liability	A/P	-50	-60	-40	-20	-50	*	*	*
6	Liability	Security	-20	-20	-20	-20	-20	*	*	*
7	Liability	Loan Payable	-200	-300	-400	-500	-600	*	*	*
Sheet2