sum true/false
=SUMPRODUCT(--(A2:A20))
--
__________________________________
HTH
Bob
"greg" wrote in message
...
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
|