SUMIF - Text & Values

I've created an example of what I'm working on since it involves personal information. See Attachment...
ExampleExcel.xlsx

I need to use 2 criteria to determine the Sum value for A2 thru A5. The Account# and the Type# below row 7 need to be the same as those listed to the right of the Sum column (A2:A5). I can change the Account# and Type# to text, but the Sum Range needs to be numbers.

I was able to Sum based on the Account range (=SUMIF(Account,B2,Sum), but I still need to make the Type range part of the criteria.

As you can see in the attachment, A2 = 8 when it should = 2 (as seen in row 8 under Sum Range).

Given you're using XL2007 you can use SUMIFS function (not available pre XL2007)

A2: =SUMIFS(Sum,Account,B2,Type,C2)

I suspect it would be best to post a sample reflective of your real data

Your Account Named Range encompasses two columns whereas in fact it should include D (see Notes)... revise the RefersTo range and the formula will work.

NOTE:

Merged Cells are horrendous and should be avoided whenever possible ... you can achieve the same effect on horizontal ranges by using "Centre Across Selection".

With Merged Cells the values within exist only in the left most (or in vertical merge the top most) cell in the range... ie even with D&E merged the values exist only in D.