To do the above I tried the following: =sum(ISTEXT(G5:G177),1)) I got this from John Walkenbach's formulas book but it's not working - can anyone tell me what's wrong?