SUMIF and COUNTIF allow for only one criterion. You need array formulas or
SUMPRODUCT if you have multiple criteria. See the other response for one way.

On Fri, 30 Sep 2005 19:11:16 -0700, AHANG JJJ <AHANG
wrote:

What is the syntax for sumif function with two criteria range and two
criteria?