View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
respinosa
 
Posts: n/a
Default How do I get text to equal a number so I can sum a column?


I have a similar problem.

Trying to get a word(s) in a column on Sheet2 to total in a cell on
Sheet1. So down Column C, how many times the word "Off" or "On"
appears to total on Sheet1 under their perspective rows of "Off" and
"On".


--
respinosa
------------------------------------------------------------------------
respinosa's Profile: http://www.excelforum.com/member.php...o&userid=35231
View this thread: http://www.excelforum.com/showthread...hreadid=549633