sum true/false
"greg" skrev i meddelelsen
...
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
Hi
Multiply by 1.
If you have True/False in A1 and down, then enter enter this formula in B1
and copy down:
=A1*1
True will equal 1 and False will equal 0.
Regards,
Per
|