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

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

"steve_k" wrote:

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

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" 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

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