If the columns are already 1's and 0's, why not just
=SUMPRODUCT(A2:A21,B2:B21)
"Bob Phillips" wrote:
Try re-typing it, it works fine, and requires no add-ins.
--
HTH
Bob Phillips
(remove xxx from email address if mailing direct)
"BCB" wrote in message
...
Thank you, Mr. Coderre.
Tried it, but got #NAME? in return.
I fear it might be required to install some of the accessories from the
Tools menu, and that's not an option for me yet. Anyway, that was just
one of several solutions suggested by Excel Help.
Thanks anyway.
B
--
BCB
------------------------------------------------------------------------
BCB's Profile:
http://www.excelforum.com/member.php...o&userid=34101
View this thread: http://www.excelforum.com/showthread...hreadid=540522