forget it....
--
A+
V.
"Vincnet." wrote:
Maybe....
Insert/Name/Define
=A1,C3,D5
as RangeTest for example
and then: =COUNTIF(RangeTest,1)
Does it help?
--
A+
V.
"nsharpe" wrote:
COUNTIF seems to require a continuous range of cells to be inserted in the
formula.
I have a series of discontinuous cells from which I wish to count all those
that have the value 1.
COUNTIF((A1,C3,D5),1) for example returns #VALUE#. Using colons as
separators does not work either.
Any suggestions?
|