sum true/false
Do the cells contain 1's and 0's or True's and False's?
How about just count the trues/falses:
=countif(a1:a10,true)
and
=countif(a1:a10,false)
=sum(a1:a10)
should sum the cells if they really contain 1's and 0's.
greg wrote:
Is there anyway of summing a bunch of rows, that contain true and false.
Where true = 1 false = 0.
I tried changing the cell to a number. with true in it. but no luck.
any other ideas?
thanks
--
Dave Peterson
|