View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SWOcala SWOcala is offline
external usenet poster
 
Posts: 2
Default Counting the ones, twos and threes - Please Help

I have been reading for some time and cannot find what I thought would be an
easy one! I need to COUNTIF or SUMPRODUCT and find how many instances of 1
appears in any number in any cell. Then, I need to do the same for the
numberals 2 and 3. Please, can someone help. I expect to be using A1 through
U1 only.
Thanks!