CountIf question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
try the following formula
=SUMPRODUCT(--(Echo!B18:B32<>"<Select>"))

--
Regards
Frank Kabel
Frankfurt, Germany

Joe said:
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
Click to expand...
which the user can enter data. The default value in the cells is
 
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

Joe said:
Frank,

Thanks. Would you explain how this works?

Joe

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

Hi
try the following formula
=SUMPRODUCT(--(Echo!B18:B32<>"<Select>"))
Click to expand...
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]
 
Back
Top