Excel Help Please
Hi guys!
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:
=COUNTIF(B59,B56,B53,B50,B47,B44,B41,B38,B35,B32,B29,B26,B23,B20,B17,B14,B11,B8,B5, ">=0")'
It gives me the error message:
Quote: The formula you typed contains an error.
Go to all the usual places etc
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.
Many thanks for your help guys!
Abhishek Reddy posted this at 00:10 — 9th February 2003.
He has: 3,348 posts
Joined: Jul 2001
Doesn't look like you can use individual cell references. You're not able to use a range (Xy:Ab)?
Timewell posted this at 00:40 — 9th February 2003.
They have: 344 posts
Joined: Jun 2002
I am but it includes cells that I do not want...
Timewell posted this at 13:52 — 9th February 2003.
They have: 344 posts
Joined: Jun 2002
http://www.cmdirector.neosurge.net/Premiership.htm
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.