Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default formula


Assuming your cells contain 1, 2 or 3 in the cell, just use a countif
statement

=countif(range,1) will tell you how many 1's etc


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555169