I have 2 columns A & B. I want Xcel to first look at Column A and IF it
contains the number 1, then go to Column B and count how many A-1's there
are. This is my formula - it's giving me a FALSE answer but I need a number.


=IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1")