Excel Help Please!

Timewell · #1 02-08-2003, 05:17 AM

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:

Code:

=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!

Tom Urtis · #2 02-16-2003, 06:49 PM

The reason you ran into problems with the formula, and with the 3rd argument in particular, is that the COUNTIF function only allows for two arguments...the first being a contiguous range (eg A1:A20 - the range being evaluated), and the second argument for the criteria, which could be a single cell range or a hard coded value.

Anyway, here's a workaround formula that should do what you want:

=SUM(COUNTIF(INDIRECT("B"&{5,8,11,14,17,20,23,26,2 9,32,35,38,41,44,47,50,53,56,59}),">=0"))