Using an example from "Count how often multiple text or number values occur
by using functions" returns #VALUE! Why? Currently using Excel 2002 with
Add-Ins Conditional Sum Wizard, Solver Add-in, and Lookup Wizard.
fx:
=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))

I have tried using other examples using COUNT and get same results.
I have two columns, one is a number the other text, that need to match two
logicals to return a sum or count of those that match.
Please help - Thanks, RickG