CountIf question

[Joe]

I am using Excel 2002. I have the following formula in a cell on a sheet named System:

=COUNTIF(Echo!B18:B32,"<Select>")-15

On the sheet named Echo, in the range B18:B32, I have 15 cells into which the user can enter data. The default value in the cells is "<Select>."

What I would like to know is how I can determine if any of the cells are populated with some value other than "<Select>." That's what I am trying to do.

Does anyone know why the above formula doesn't work or what else I could do?

TIA,

Joe

 

[Frank Kabel]

Hi
try the following formula
=SUMPRODUCT(--(Echo!B18:B32<>"<Select>"))

--
Regards
Frank Kabel
Frankfurt, Germany

I am using Excel 2002. I have the following formula in a cell on a sheet named System:

=COUNTIF(Echo!B18:B32,"<Select>")-15

On the sheet named Echo, in the range B18:B32, I have 15 cells into

which the user can enter data. The default value in the cells is

 

[Frank Kabel]

Hi
this loops through the range and checks each row. The '--' coerces then
the boolean values to numeric values (TRUE=1/FALSE=0)

--
Regards
Frank Kabel
Frankfurt, Germany

Frank,

Thanks. Would you explain how this works?

Joe

----- Frank Kabel wrote: -----

Hi
try the following formula
=SUMPRODUCT(--(Echo!B18:B32<>"<Select>"))

cells into
which the user can enter data. The default value in the cells is the cells
are populated with some value other than "<Select>." That's what I am
trying to do. else I
could do?
[/QUOTE]

 

[Alan Beban]

=COUNTIF(Echo!B18:B32,"<><Select>.")

Alan Beban