Count the occurence of more than one condition

W

wutang1105

Got this function from Excel Help but it gives me #Value error. Ca
anyone help?





=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))

Number of invoices for Buchanan with a value less than 9,000. (1
 
B

Bob Phillips

It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top