Brute force.......

=SUM(COUNTIF(A1,1),COUNTIF(C3,1),COUNTIF(D5,1))

Vaya con Dios,
Chuck, CABGx3



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