Got this function from Excel Help but it gives me #Value error. Can 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)