Excel Array Formulas

Product	Salesman	Units Sold
Fax	Brown	1
Phone	Smith	10
Fax	Jones	20
Fax	Smith	30
Phone	Jones	40
PC	Smith	50
Fax	Brown	60
Phone	Davis	70
PC	Jones	80
	Summing Sales: Faxes Sold By Brown
		61		=SUM((A2:A10="Fax")*(B2:B10="Brown")*(C2:C10))
	Logical AND (Faxes And Jones)
		2		=SUM((A2:A10="Fax")*(B2:B10="Brown"))
	Logical OR (Faxes Or Jones)
		6		=SUM(IF((A2:A10="Fax")+(B2:B10="Jones"),1,0))
	Logical XOR (Fax Or Jones but not both)
		5		=SUM(IF(MOD((A2:A10="Fax")+(B2:B10="Jones"),2),1,0))
	Logical NAND (All Sales Except Fax And Jones)
		8		=SUM(IF((A2:A10="Fax")+(B2:B10="Jones")<>2,1,0))