Kind of Sumif but with 2 criteria

[pmarques]

I need a kind of sumif but with two criteria.

For Example (see attach):
In cell B13 returnes sum of ITEM where criteria is “John” (NAME) and XPTO Nonblank

Total John = 2 (A2+A6+A10 the A5 was excluded because C5 is blank)

How can this be done with formulas


Thanks

[davesexcel]

try sumproduct

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[pmarques]

try sumproduct

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

It works
=SUMPRODUCT(--($B$2:$B$10="John"),--(NOT(ISBLANK($C$2:$C$10))),$A$2:$A$10)

Thanks

Note: The example attach, that i give, as a mistake total john is 1 not 2