I have encountered a problem with Microsoft Excel. The following formula does not seem to work for some reason and I nor another good friend can see why. Can you guys help me?

The formula is:

Code:

`=COUNTIF(B59,B56,B53,B50,B47,B44,B41,B38,B35,B32,B29,B26,B23,B20,B17,B14,B11,B8,B5, ">=0")`

I have noticed however that when I was clicking on the cells to give them the range, that the first three had coloured boxes around them and the rest hadn't for some reason. It keeps indicating that cell B53 has an error in it but it is a blank cell.The formula you typed contains an error.

Go to all the usual places etc

Many thanks for your help guys!