View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
JMB
 
Posts: n/a
Default Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. con

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