number of cells
=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
|