number of cells

[steve_k]

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

 

[Toppers]

=COUNTIF(INDIRECT(C1),">=0.5")

 

[PCLIVE]

If you want to SUM the cells that are greater than or equal to "0.5" then:

=SUMIF(INDIRECT(C1),">=0.5")

If you just want a count of cells whose values are greater than or equal to
"0.5" then:

=COUNTIF(INDIRECT(C1),">=0.5")

HTH,
Paul

 

[steve_k]

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