ADVERTISEMENT
You might want to test that cell A1 contains a number first:what if a1 is a formula that calculates a value
ex a1
if(b1="","",countif(b10:b2000,"s")
which equals 4567
its not giving the right answer
but if i manually type 4567 in it does