please ignore, i just had to read down further in the threads to generate an
idea.

just in case anyone cares
==COUNTIF(INDIRECT(C1),""&TEXT(MAX(INDIRECT(C1))/2,"0.00E+00"))

apologies if i caused someone unnecessary work
Steve

"steve_k" wrote in message
...
in column A are numbers ranging from 0 to 1. in cell C1 is the text (or
label) specifying the cell range for those numbers A1:A500. i know i can
use the INDIRECT() function with SUM() to get the sum of those numbers
with =SUM(INDIRECT(C1)). however, what i really need is a function that
returns the number of cells with a value = 0.5. it should be something
similar to =SUM(INDIRECT(C1)0.5). I need to avoid functions like DCOUNT
and the like. just trying to get a Quattro Pro workbook transferred to
Excel.

TIA,
Steve