BTW, this should also work... =SUMPRODUCT((A:B="z")*(C:C))